user9077483 wrote:You will surely need to decrease the sample parameter.
I have used the following statement to gather the stats of a table..
To gather the stats it is taking one hour and the table SALE_AMT is having 237213998 records.
Please help me is there any way to get the stats quickly.
Thanks in advance.