Hi,
I ran this analyze command on a table and it doesn't
seem to populate the last_analyzed/degree columns in
the user_indexes table. I saw it is done in the
user_tables.
> analyze table table_a estimate statistics for table
for all indexed columns sample 20 percent;
anyone knows why? (I am on 8174)
benny
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Oracle LazyDBA home page