Re: What index access path does INDEX_SS yield ?

Jonathan Lewis wrote:

> Think how many times people on this newsgroup have said
> "Oracle has a bug" and then produced a piece of (unhinted)
> SQL that shows they don't understand how SQL works.
> Very few of them said things like "Oracle is ignoring my
> subquery" - and I don't think I've ever seen anyone reply
> "that's because Oracle can ignore subqueries". (Though
> they may be true in 10gR2 occasionally).

Well said.

Your last comment caught my interest. Would you have an example of Oracle ignoring a subquery you could share?

Thanks.

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