Index in different tablespace
I have a disk raid 1 mirror, that has the os.(windows 2000), and copy of online redo logs and control files.
And a raid 5, that has the database(2 gig).
I have only 1 tablespaces that contains my tables(638) and indexes(993).
I think that one of the good reason to keep index in a different tablespace is the save the io on disk. But since im on a raid 5, i dont see the utility to put the indexes on a different tablespace.
My tablespace is a localy managed tablespace with uniform extent 128k.
Do you have more arguments on why to put indexes on different tablespace. Maybe to use a tablespace with bigger extent?