Oracle Database Discussions

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!

Problem with the minus operator - Urgent

user607782Apr 15 2009 — edited Apr 15 2009

Hi,

I am executing one source minus target query which is taking a lot of time to run (more than a day) in TEST and PROD environment.
But when i run the same query DEV it is workin fine giving results in few seconds.

Individual query is also takin less time as there are only some 10k records in target table and in source depending upon the date condition(max 500 rows).
I checked the indexes of DEV, test AND PROD. All are same.

Can any one help me in this.
ASAP.

Thanks in advance,
Harsha

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2009

Added on Apr 15 2009

#general-database-discussions

17 comments

1,150 views