DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: follow up question on resize

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Question

    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?

  2. #2
    Join Date
    Nov 2000
    Posts
    205
    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.

    Good luck,
    Nirasha

  3. #3
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    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.
    Rajeev Suri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width