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!

Openquery from MS Sql Server

user6428880Apr 28 2010 — edited Apr 28 2010

Hi all,
I encounter a situation where when I send a select statement to a Oracle DB using openquery from a sql server, the first run would always timed out in around 30 mins. But when I sent the same query again within 10-15mins. The result set came back in 22 mins.

Is it because Oracle had stored the execution plan after the first query and as a result, the second query returned in a much faster time?

Thanks all

Locked Post

New comments cannot be posted to this locked post.

Locked on May 26 2010

Added on Apr 28 2010

#general-database-discussions

1 comment

919 views