In my last post about temporary tablespace, I talked about monitoring the usage during an index creation since it is one of activties which need sort segments. One question likely arises is how to estimate the size of an index so that we can add enough temp data files and data files ahead? If you … Continue reading How big will be the new index? →