Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: Why would 2 schemas in same instance with identical tables and data display 10 fold diff in speed

From: Narendra Puppala <n_puppala_at_yahoo.com>
Date: Tue, 17 Aug 1999 21:47:42 -0500
Message-ID: <7pd6mg$76s$1@ionews.ionet.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US