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
Did you use explain plan and tkprof? IF not, read about them and go from there. Received on Thu Jan 09 2003 - 21:54:58 CST