in the near future, one of our tables is gettinga datadump of 2million rows added. I have been asked to give a report on the effect of this. Its as general a request as that....For the table, I can guestimate the new space required from the avg row length. I can even go and find the SQL in v$sqlarea that accesses the table and mat be affected by higher number of records.
The bit im stuck on is indexes. I know that you can analyse the indexes and get info from INDEX_STATS. What I dont know how to do is how to interpret this, and if there is anything there that is appropriate for this report (how uill 2M extra entries affect the indexes).