Re: Straight SQL always put perform PL/SQL?

Charles Hooper wrote:

> The question probably should have been asked, were the correct,
> accurate statistics gathered by the OP's ANALYZE command to allow
> Oracle to use the index access? Or was the index actually used, but
> there were also two full table scans that the OP saw and assumed that
> Oracle only used full table scans?
>
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.

Likely too the ANALYZE command is unaware of a number of index types and options developed in the last decade.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org