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?
Post the query.
Post the explain plan (created using DBMS_XPLAN)
Post the Oracle version number (to 4 decimal places)
Post the DDL for existing indexes
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Mon Oct 02 2006 - 18:50:49 CDT
