Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index does't hit with NULLS LAST for desc column

user644332Aug 5 2008 — edited Aug 6 2008
When i use NULLS LAST with order by clasuse for field with desc, index soppose to hit won't hit, any idea?

E.g
select *
from table_test
order by column1 desc NULLS LAST

index for column1: without NULLS LAST index hits as expected,but with NULLS LAST index does't hit as expected.

Thx,
As
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2008
Added on Aug 5 2008
12 comments
893 views