Hi all,
I have a doubt, do we really need to gather or analyze stats for a table to know its actual size. this is very important because, in our environment, tables data changes rapidly and we will be doing exporting to other database. Before doing export, we need to estimate the actual size of the table. we do that by running gather stats on it.
Please tell me is it necessary to gather stats for estimating the actual size of table?