Re: sql query not use index
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 10 Mar 2009 22:48:21 +0100
Message-ID: <49b6e02b$0$188$e4fe514c_at_news.xs4all.nl>
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:1277166300346684168
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6749454952894#6760861174154
>
>
Date: Tue, 10 Mar 2009 22:48:21 +0100
Message-ID: <49b6e02b$0$188$e4fe514c_at_news.xs4all.nl>
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:1277166300346684168
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6749454952894#6760861174154
>
>
Oops, you forgot the exception clause.....
Shakespeare Received on Tue Mar 10 2009 - 16:48:21 CDT