Rebuilding Histograms - Single columns vs. all columns

I discovered over the weekend that we apparently have old histograms generated for every column in every table of one of our production databases. We don't need all of these histograms but the existence of the aged ones is fouling up the database. I'm not sure which ones can be safely removed at this point (I've been here less than two months) but while we're trying to figure that out, I've got to recreate them so they're at least fresh.

I'm looking at the analyze command and the FOR clause to generate these histograms. I need a histogram recreated for every column in every table. Which clause is best to use:

for table
for table for column (repeat for every column in the table)

If I just use the for table clause by itself, what will that do? Will it generate histograms
for all columns in that table?

Thanks, Received on Mon Aug 14 2000 - 06:40:47 CDT