index range scan vs. an index full scan
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 4 May 2004 11:59:25 -0400
Sometimes when oracle performs a join it does an index range scan which tend
be perform well.
However, sometimes oracle performs an index full scan which does not perform
well.
what influences oracles decision in choose what type of index scan to use?
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
