Indexes into special tablespace

[hesperornis]

Is it usefull when you put all indexes from all schemas into one tablespace ? but i came across some indexes of IOT type, that cannot be moved

[davey23uk]

not really no

[sunil_kandi]

index is dependent on the table and it will be useful to put table and index in different disks to optimize the disk i/o. if you are striping across multiple disks then probably, having tables and indexes on separate disks wont help.

[mike9]

Hesperornis,

Why should it be usefull?
Which advantages do you expect from it?

[pando]

index is dependent on the table and it will be useful to put table and index in different disks to optimize the disk i/o.

that is not true

[robertbalmer]

Hesperornis

goto http://otn.oracle.com and read everything on indexes,then you can make your own educated presumption

[sunil_kandi]

can u tell me why having tables and indexes in seperate disks wont help. i suppose tht will optimize i/o.

[pando]

because the I/O in an index scan is serialized