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 -> oracle indexes and scripts

oracle indexes and scripts

From: Ollie <quantumtech_98_at_yahoo.com>
Date: 9 Jan 2003 12:36:09 -0800
Message-ID: <caea3840.0301091236.6ed13b7e@posting.google.com> 





Oracle indexes & analyze question.




I have four queries I am running against three tables. I have created
some indexes on the tables. After creating the indexes I ran the
analyze command.




one of the queries is much faster after doing this while the three
other queries are mush slower.




I delete the statistics and then rerun the queries, now the three are
much faster while the one is very slow.




Can anyone tell me what is going on here?




Thanks
Received on Thu Jan 09 2003 - 14:36:09 CST












Original text of this message













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