Re: Different execution plans for similar schemas on same query

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 17 May 2002 19:13:30 +0200
Message-ID: <ugeaeugqi2slc8rjiep3310rkubbi3sun6@4ax.com>

On Thu, 16 May 2002 19:28:59 -0600, "Leigh Gold" <intan_5ee_at_yahoo.com> wrote:

>I did run the 'analyze table' and 'analyze index' after the import, will
>using dbms_stats makes some different?
>
>Interestingly, I ran the same query on different schemas on a 8.1.6 WinNt,
>and AIX 8.17, the 8.1.6 also use index scan, and the 8.1.7 use the full
>table scan. Coincident, perhaps?
>
>Leigh

dbms_stats is supposed to produce more accurate statistics

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 17 2002 - 12:13:30 CDT