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!

Orphan Records

sm12Feb 9 2015 — edited Feb 12 2015

Hello,

we have few tables with millions of records, need to be compared periodically to identify the orphan records. we use the minus logic to compare these tables but will take the queries long time. Are there any better ways in oracle 11gR2 to compare these tables to reduce the overhead on the database and as well as reduce the time to compare the tables data.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 12 2015

Added on Feb 9 2015

4 comments

411 views