Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Full table scans and USE_HASH hint
If I process a query in parallel, will USE_HASH hint automatically cause full table scans even if there are indexes present? Or do I have to specify a FULL hint as well to ensure that the tables are scanned for the parallel processing?
Thank you!
Sergey
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Sep 22 2000 - 11:41:59 CDT