Analyze Table

From: Sathish Balas <sathishudercor_at_home.com>
Date: Mon, 02 Jul 2001 23:59:20 GMT
Message-ID: <sV707.141042$qc.16784868@news1.rdc1.va.home.com>

What factors to consider before analyzing a table ?

We have a table with 15mil rows . We have been analyzing every week . I just do a analyze table <table_name> estimate statistics 33 per cent ; (not the exact syntax) . I read somewhere that do an estimate of 20 % and analyze just the indexes . If the data is skewed a lot then generate histograms . Is this the right approach ?

And i want to do the analyze in parallel ? How do i do it ? Can you point to documentation please ?

Thanks
Sathish Received on Mon Jul 02 2001 - 18:59:20 CDT