Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle indexes and scripts
Ollie wrote:
> 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
Let me guess ... your problem is that you're running Oracle6 on an IBM
AT/286 ... am I right ... huh ... huh?
Seriously, without any hints about what version of Oracle you're using, it's pretty hard to make a definitive answer. Maybe you could post your explain plan ... or redo the analyze command and put a /*+ RULE */ hint on the 3 queries that slowed down to see if they're still slow. Received on Thu Jan 09 2003 - 15:35:05 CST