Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why would 2 schemas in same instance with identical tables and data display 10 fold diff in speed
The Oracle optimizer tries to optimize all operations based on statistics
(COST based) about the tables. If the statistics are not current, the mode
that Oracle chooses is RULE based which may not be as fast as the COST based
approach. You can run the analyse table command on your database tables to
update the statistics. This could fix your problem.
Received on Tue Aug 17 1999 - 21:47:42 CDT