List:MaxDB« Previous MessageNext Message »
From:Daniel Castro Date:July 2 2007 7:21pm
Subject:Update Statiscts SAMPLE_ROWS
View as plain text  
Hi,

I want to know the % of rows to be used as sample_rows for a table, because
I get the following message:

I  1 tables contain > 1.000.000 records but only 20.000 rows will be sampled
for statistics
      CON: NUM_TABS_FEW_SAMPLE_ROWS > 0
      VAL: 1

Is there any pattern?
How I change this value?

Best Regards,

-- 
Daniel Castro - דניאל
MSN: danielti@stripped
Skype: danielti2005
ICQ : 316727989
Jabber: danielti
Linux User: 387864
AOL User: Danielti2005
Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria
Thread
Update Statiscts SAMPLE_ROWSDaniel Castro2 Jul
  • RE: [LIKELY JUNK]Update Statiscts SAMPLE_ROWSHolger Becker3 Jul