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: Performance difference issue between two users of the same database

Re: Performance difference issue between two users of the same database

From: <AK_TIREDOFSPAM_at_hotmail.COM>
Date: 27 May 2005 09:37:18 -0700
Message-ID: <1117211838.017049.41380@g43g2000cwa.googlegroups.com> 





Just one more possibility:



even if you have exactly the same data in both schemas, the physical
order of rows could be different. So similar indexes might have very
different clustering factors.


Hence different execution plans. In this situation even if you force
the optimizer to choose one and the same plane on both schemas, you'll
heve very different real execution costs.
Received on Fri May 27 2005 - 11:37:18 CDT












Original text of this message













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