drop and recreating Index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: drop and recreating Index

  1. #1
    Join Date
    Jul 2001


    In a warehouse daily i am dropping particular 4 indexes before loading the data. After loading the data again i am creating the indexes, This is going on regularly.
    The problem is daily the no of record is increasing. so index recreation time is increasing day by day. Any one please give good suggestion. My table is already partiotioned and the indexes are in seperate tablespace. During the index creating i am using pctfree 0 Local Nologging.

  2. #2
    Join Date
    Feb 2001
    Paris, France
    are you loading data in ALL your partitions ???
    if not, create a local index which indexes the partitionning key, and just drop the index corresponding to the update partition

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