Re: dbms_stats

From: jaromir nemec <>
Date: Wed, 3 Jun 2009 13:37:17 +0200 (CEST)
Message-ID: <>


> so from my test , i show analyze is better than DBMS_STATS..... Any
> other ideas plz

This shows first of all that the second test runs better then the first one. This could be a result of caching.

I'd suggest:

  1. run the selects with autotrace on to see if you have different execution plans
  2. repeat the runs to see the ratio of logical and physical I/O (also visible in autotrace output)

HTH Jaromir

Received on Wed Jun 03 2009 - 06:37:17 CDT

Original text of this message