By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

query results slow from db

P: n/a
Hi - I have a query which extracts data from multiple tables (9i
server), one of the tables is on a remote server with 8.1.7 Oracle
running on it.

Whenever this query is run, the performance is really down as compared
to when the query was run before on both 8.1.7 versions of oracle.
Now that we have to migrate one of the oracle versions to 9i, this has

Can anyone help with this ? We have no control over the remote db
server which is running in 8i and no idea when they are going to
convert to 9i.

The query is straight forward - some thing like this:

select a8i.x, b9i.y, c8i.z
from a8i, b9i, c8i
where a8i.x = b9i.y

Appreciate your time and help.
Thank you.
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.