Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2010
    Posts
    21

    Unanswered: Dropping indexes while loading the data

    Hi All,
    Please help on this :

    I want to drop the indexes of a table while loading the data into table as load is taking too much time in building the indexes. Is this possible..please revert asap its very urgent.


    Regards,
    Harsh Verma

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    if the load is in progress, you cannot.

    this is true in case of db2. don't know what database you are talking about as you haven't mentioned.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by harshrpce View Post
    I want to drop the indexes of a table while loading the data into table as load is taking too much time in building the indexes
    You'll probably have to (re)build the indexes anyhow after the load finishes, that is: the "create index" will do that.
    So it's not necessarily a good idea to drop indexes before starting the load.
    (It could be, sure; but all depends on a lot of other aspects.)
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  4. #4
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by harshrpce View Post
    Hi All,
    Please help on this :

    I want to drop the indexes of a table while loading the data into table as load is taking too much time in building the indexes. Is this possible..please revert asap its very urgent.


    Regards,
    Harsh Verma
    if it is not an index enforcing PK or unique constraints.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •