Re: EXPLAIN Plan

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 2 Oct 2006 15:23:40 -0700
Message-ID: <1159827819.919951.74400@i42g2000cwa.googlegroups.com>

Dereck L. Dietz wrote:
> Earlier today my manager sent an EXPLAIN PLAN to a number of us for help
> with a query. In the EXPLAN PLAN there was an INDEX RANGE SCAN which the
> off-site DBA said was caused by the table not being analyzed.
>
> The INDEX RANGE SCAN was using an index - maybe not the one I'd expect but
> nonetheless was using an index on the table being EXPLAINED.
>
> Am I missing something or does what the DBA not really make sense?

Index range scans can be used very effectively by the oracle query optimizer in several different types of queries.

Jonathan Lewis in his new book as well as Tom Kyte ( see http://asktom.oracle.com ) have lots of examples. Received on Mon Oct 02 2006 - 17:23:40 CDT