I can understand not gathering histograms across all columns due to the
potential time it would take to do so. Is there any other technical reason not
to..(perhaps some issue with the optimizer I'm not currently aware of)?
I routinely gather histogram information for all INDEXED columns.
Matt Adams
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Wolfgang Breitling
Sent: Monday, November 09, 2015 12:13 PM
To: kp0773@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: gather stats
Use auto_sample_size and refrain from gathering histograms on all columns (
method_opt 'for all columns size 1')
Sent from my iPhone. Typing errors may have occurred.
On Nov 9, 2015, at 10:01, K R <kp0773@xxxxxxxxx> wrote:--
All,
What is the recommended way of gathering stats on 11gR2 database ( 2.5 TB)
. If i keep estimate percent 10,15 then some of the table are taking hours
and hours .
Please let me know .
Thanks in advance.
Kart.