Re: oracle indexes and scripts

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 09 Jan 2003 22:07:21 +0100
Message-ID: <l3pr1vgk4pqjicot7hb623ds0ih7fdr381@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:07:21 CST