I am running in a DSS environment. I have resized my tablespace(datafile) to 500m from 1200 m because I over alloacted space. The objects in the data tablespace will not be seeing any more addition or subtraction of data..i.e it will be static.
The data tablespace in question has a corresponding tablespace that contain only indexes. The space in the index tablespace was also over allocated. 400m has been used so far out of the 700 allocated.
Even thought the data tablespace is not going to see any more inserts, updates or deletes, it's going to see a lot of queries to get information. I know that the indexes make those queries faster.
Since only 400m was used by the index tablespace, I want to resize the index tablespace to about 420m. My question is, can I resize it just like I did for the data tablespace knowing that there is going to be a lot of select queries and theses queries depend on the index for speed?
From my understanding, queries will be using the existing indexes. You say that there will not be updates to the data, so that means the indexes won't be growing as well. As far as I know, you should be able to resize the datafile without a problem.
only Inserts and Updates (of the columns forming the index) may cause index to grow. This is not the case in your scenario so you can resize the datafile without any problem.
Click Here to Expand Forum to Full Width