Skip to Main Content
Forums

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!

query too slow due to distinct keyword

shahid_ahmed_patelFeb 12 2009 — edited Feb 18 2009
hi all,

I am slelect data from a table which has millon of rows works fine with where and etc because of index
but if i apply distinct keyword in start it take long time to execute..

is there any way to make it fast..

the query is

select ordr_code,ordr_date from orders << fast

select distinct ordr_code,ordr_date from orders << fast
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2009
Added on Feb 12 2009
10 comments
7,630 views