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!

select Without using DISTINCT and ROW_NUMBER OVER(PARTITION BY .. ORDER BY)

user12236189Oct 14 2011 — edited Oct 14 2011
Hello,

I have table with over couple of billion records
Without using
DISTINCT and
ROW_NUMBER OVER(PARTITION BY .. ORDER BY)
----Both taking heavy usage on the TEMP and cost
How can I select only distinct records.

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2011
Added on Oct 14 2011
12 comments
2,009 views