DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: indexes/PK's

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    How do you drop and re-create indexes which were created at the time primary key were created?

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Thumbs up


    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
  •  


Click Here to Expand Forum to Full Width