estimate_percent size on gather_stats

From: Shankar <shan0075_at_yahoo.com>
Date: Sat, 20 Jul 2002 03:08:16 GMT
Message-ID: <3D38D583.7020402_at_yahoo.com>

What is the appropriate estimate_percent on gathering stats for huge warehouse kind of tables ? Compute is not a option, as it takes longer time to complete. Is there any math behind the total bytes used by the segment that can closely match and lead to optimal execution plans.

thanks,
Shan Received on Sat Jul 20 2002 - 05:08:16 CEST

This message: [ Message body ]
Next message: Prem J Khanna: "resizing/moving datafiles for performance ??"
Previous message: Iker: "Convert Java applications into Oracle Portlets"
Next in thread: Sybrand Bakker: "Re: estimate_percent size on gather_stats"
Reply: Sybrand Bakker: "Re: estimate_percent size on gather_stats"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message