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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 23:22:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.