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 -> Estimate or analyze statistics

Estimate or analyze statistics

From: hellothere <hellothere_at_yahoo.com>
Date: Wed, 01 Nov 2000 21:07:08 -0800
Message-ID: <3A00F67C.719DE5C0@yahoo.com> 






Running Oracle 8.0.5 on Solaris 2.6


I apologize in advance if this has been addressed, but are there any
hard and fast rules


about estimating vs. analyzing statistics?  I've seen table size
mentioned, as well data skew.


Is it even feasible to analyze and compute statistics on tables in the
multiple gigabyte range (20+ GB)?



TIA

Received on Wed Nov 01 2000 - 23:07:08 CST












Original text of this message













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