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