Look at /* USE_HASH */ hint to force hash join. Whats your init.ora compatible parm set to 81x or 90x ??
May be its using 81x optimizer even in 9i ?
|
Results 1 to 4 of 4
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote