RE: CBO not using the index even though it is faster when hinted

John ....

"This is not to distract you from the original problem, but Direct Path Reads/Writes is I/O that bypass the Db block buffers to read directly into PGA, and is typical of sort I/O and PQ (among many other reasons)."

Thanks on this .... See note I sent just before this on what I did. Bottom line is the query now returns thousands of rows in a spilt second as opposed to the 8 seconds it took before.

I believe when we were at IOUGA last year, I think Tim or Wolfgang said to be careful loading up on the hints 8i and beyond.

Mike

-----Original Message-----
Sent: Friday, January 24, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L hinted

Mike,

> several Direct_Path_Write and Read waits with large elasped times
> are showing up in the 10046 trace data on this query due to the
> full table scan.

This is not to distract you from the original problem, but Direct Path Reads/Writes is I/O that bypass the Db block buffers to read directly into PGA, and is typical of sort I/O and PQ (among many other reasons). I mention this as your original query does have a sort at the end... (Apparently, Direct read/writes is also used when async I/O is configured and used, but I will let the gurus address that!)

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

I don't know what the future holds for me, but I do know who holds my future!

• The opinions and statements above are entirely my own and not those of my employer or clients **

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Johnson, Michael 
  INET: Michael.Johnson_at_oln-afmc.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).