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!

SQL Tuning Advise

3206Oct 20 2003 — edited Oct 20 2003
Hello
I have a very huge table to join itself.

SELECT
.....
FROM huge_table a,
(select id,MAX(txndate)
from huge_table
where .....
group by id) b
WHERE a.id = b.id
AND a.txndate = b.txndate;

I found this statement really a time-consuming statement after execute it. Anyone have good idea to tune this ?
Thanks

Regards,
ckwan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2003
Added on Oct 20 2003
1 comment
107 views