Originally posted by slimdave
number of empty blocks etc., and both of these will make a difference to the stats.
Dave :
Dbms_Stats always updates this col with zero if Null.. & oracle suggests to use Dbms_Stats instead of Analyze ( which will fill in the number of blocks that are empty ).. Do u think its important??
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"