Indexes

I wnat to find out how to move indexes from one tablespace to another and rebuilding them at the same time without recreating them

Hi,

ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;

That will work...

Thanks very much. I am yet to see the whether performance has improved.