Analyze Columns

From: Oliver Stratmann <stratmo_at_gmx.de>
Date: Tue, 15 Apr 2003 12:36:06 +0200
Message-ID: <b7gnam$n7ib$1@ID-180535.news.dfncis.de>

Hello All,

I have some questions about nalyzing tables and specific columns.

We analyze our tables by
"ALTER TABLE tabname COMPUTE STATISTICS" and afterwards
"ALTER TABLE tabname COMPUTE STATISTICS FOR ALL COLUMNS"
Does the second command enrich the tablestats or rewrite them? (Which would mean, that the second one would do all the work!)

Now we are in a situation where a column has to be updated. I think we need to refresh the stats afterwards.
Do I need both the Commands stated above? Is the second one sufficient?
Or is it enough to do "ANALYZE TABLE tabname COMPUTE STATISTICS FOR COLUMNS colname"?

Thanks for your help in advance!

Have a nice day!

Oli Received on Tue Apr 15 2003 - 05:36:06 CDT