Thanks for the reply Tim Hall..

Just as a quick note... since few people suggested to sample the statistics of the table..

Say I analyze 10% of the table.. (or 1.4GB)

Analyze table estimate statistics 10%;

and I make this a cron job to run every night, will this ensure me to have the entire table analyzed in 10 days or so, since the table will be dynamic aswell.. What about the indexes, part ??


When I estimate for 10% as I mentioned, what all should I be looking for?


Thanks, ST2000
Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules



Click Here to Expand Forum to Full Width