How do you drop and re-create indexes which were created at the time primary key were created?
Printable View
How do you drop and re-create indexes which were created at the time primary key were created?
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