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).
Click Here to Expand Forum to Full Width