Re: oracle indexes and scripts

Or, as Sybrand no doubt means: we miss quite a few variables. Without any clues about the tables (how large, number of rows, indexes etc), the server it is running on, the Oracle version you are using, at least the execution plan of the fast version opposed to the slow version etc., etc. nobody can give you any real help. Just a few wild guesses that wouldn't be of real help.

Peter

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> schreef in bericht news:l3pr1vgk4pqjicot7hb623ds0ih7fdr381_at_4ax.com...
> On 9 Jan 2003 12:36:09 -0800, quantumtech_98_at_yahoo.com (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
>
> No, crystal balls have sold out here
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu Jan 09 2003 - 15:49:26 CST