index range scan vs. an index full scan

From: <ryan.gaffuri_at_cox.net>
Date: Tue, 4 May 2004 11:59:25 -0400
Message-Id: <20040504155923.JPEF19546.lakermmtao04.cox.net@smtp.central.cox.net>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue May 04 2004 - 10:58:29 CDT