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 -> how to analyze table estimate?

how to analyze table estimate?

From: Joe Sath <dbadba62_at_hotmail.com>
Date: Fri, 13 Sep 2002 11:31:22 GMT
Message-ID: <e0kg9.1146$kv3.863@nwrddc01.gnilink.net>

Could someone tell me how much percentage should we use to estimate statistics?
ie,
Analyze table xxx estimate statistics sample how much percent?

I usually use 10 percent, is that enough?

Thanks for your reply Received on Fri Sep 13 2002 - 06:31:22 CDT

Original text of this message

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