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
    Posts
    5

    Angry

    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
    Location
    Paris, France
    Posts
    809
    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