| Joins in Queries [message #170341] |
Wed, 03 May 2006 07:17  |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hi,
Regarding -> Oracle 9i Release 2
I understand that statistics and data in the tables decides which join (Sort Merge or Nested Loop or Hash) will be performed on queries involving joins.
Also for getting first few rows faster Nested Loop join is better.
however in all other cases which join is better than the other considering CBO and statistics taken properly (including histograms) ?
If that is not the case why we may use hints for NL or MERGE etc.
Please suggest
Thanks in Advance,
Pratap
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
