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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Performance Problems Oracle 8.0.6 on NT 4.0 / Compac-Server

Re: Performance Problems Oracle 8.0.6 on NT 4.0 / Compac-Server

From: Christian Greven <greven.christian_at_baufeldt.de>
Date: Fri, 24 Nov 2000 11:28:36 +0100
Message-ID: <8vlfop$hkl$03$2@news.t-online.com> 







Barbara Kennedy <barbken_at_teleport.com> schrieb in im Newsbeitrag:
pG7T5.13641$pZ1.805009_at_nntp3.onemain.com...


> Yes, and what is the explain plan in both cases.





After analyze on both systems says the explain plan: Full scan on all
tables.



Before some indexes have been used. There are good indexes for this
sql-statement.



Bye,


Christian.
Received on Fri Nov 24 2000 - 04:28:36 CST












Original text of this message













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