Home » RDBMS Server » Performance Tuning » Leading hint
Leading hint [message #65558] Tue, 26 October 2004 04:02
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hi,

I am a bit confused regarding Leading hint in SQL statement tuning.How do i recognise that Leading hint is required for the SQL statement and how do i identify which table should be kept as Leading for an SQL statement.

Can anybody tell me a way that how do i identify for a SQL statement that leading hint on a specific table in the query will help me in optimisation and on which table i should apply the hint.

Pls. help me on this.

Thanks in Advance.

Milind
Previous Topic: Index not used by SQL
Next Topic: Database Buffer Cache
Goto Forum:
  


Current Time: Thu Mar 28 16:36:47 CDT 2024