Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need opinions on "Compute Statistics"

Re: Need opinions on "Compute Statistics"

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 04 Jun 2003 21:12:51 +0200
Message-ID: <b5hsdv0kqsbgt1i8eac1lk4h1q5d6md72p@4ax.com> 





On Wed, 04 Jun 2003 19:42:43 +0200, Sybrand Bakker
<gooiditweg_at_sybrandb.demon.nl> wrote:



...


>>1. If I use a statement like "ANALYZE TABLE A_PRODUCT_DETAILS COMPUTE

>>STATISTICS" is this computing the statistics on the indexes also?

>NO. You need the cascade option



...



Sybrand, you are confusing COMPUTE STATISTICS (which computes the
statistics on the indexes also) with VALIDATE STRUCTURE.



Jaap.
Received on Wed Jun 04 2003 - 14:12:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US