Performance problem

From: Shankar <shankarvs_at_gmail.com>
Date: 20 Jul 2004 16:25:55 -0700
Message-ID: <3dc522c8.0407201525.10c76579@posting.google.com>

hello,
We are moving one of the user from one database ( database A) to another database (database B)

Both are cost based and query executed against the db A comes back in 10 seconds (its a big query), but it takes about 2 minutes+ in the db B.

Server configuration are same ( db A's server and db B's server) and all the parameter set up for db A and db B are exactly same.

Currently user count on each server is also very minimum. Explain plan for the query is same for both the dbs.

so what are we missing? why so much difference in the performance? Received on Tue Jul 20 2004 - 18:25:55 CDT