Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Rebuilding Histograms - Single columns vs. all columns

Rebuilding Histograms - Single columns vs. all columns

From: <Cherie_Machler_at_gelco.com>
Date: Mon, 14 Aug 2000 06:40:47 -0500
Message-Id: <10589.114483@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US