Using different tablespaces (on different disks)
for a table and its index
produces better performance
than storing the table and index
in the same tablespace, due to
reduced disk contention.



select 'alter index '|| OWNER ||'.'|| INDEX_NAME ||'
rebuild
tablespace INDX01;'
FROM dba_indexes
where owner = '*owner*'
AND tablespace_name = '*table_name';

outpuut would be like:

alter index V0108.SYS_C0016832
rebuild
tablespace INDEX02;

- Magnus