Originally posted by sonaliak
Is it a good idea to have separate tablespace for indexes ?
In what cases would you prefer separate tablespace for indexes. What are the adavantages of having separate tablespace for indexes and the rest of the database.

Does it improve performance by any ways ? If so how ?

thanks
sonali
I like to put indexes in their own seperate tablespace, always. It will improve performance if the datafiles for the index tablespace reside on a seperate device than the data. If the index and data tablespaces reside on the same disk, you performance improvement is negligible...