-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|