Re: sql query not use index

From: <sydneypuente_at_yahoo.com>
Date: Thu, 12 Mar 2009 03:54:07 -0700 (PDT)
Message-ID: <ad72e15c-ea44-4dda-926a-0caa7d02cfeb_at_t3g2000yqa.googlegroups.com>

On 10 Mar, 21:48, Shakespeare <what..._at_xs4all.nl> wrote:
> SEJ schreef:
>
> > loop
> >    say to yourself indexes are not all goodness
> >    say to yourself full scans are not all evil
> >    exit when (you believe those two statements are true)
> > end
> > loop;http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1...
> >http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6...
>
> Oops, you forgot the exception clause.....
>
> Shakespeare

Thanks guys - just the sort of input I need! Received on Thu Mar 12 2009 - 05:54:07 CDT