Post reply

drop and create INDEX in ETL

  • December 10, 2013 at 12:37 am

    #301216

    Hi All,

    I am siply loading and updating data from one table to another.But data is huge and number of column are also high. So i want to drop index initially and once data is loaded then i need create index on that table. In the target table there is no primary key.

    How can i aschieve this? please suggest ideas.

    Thanks

    Abhas.

  • December 10, 2013 at 12:47 am

    #1672217

    abhas (12/10/2013)

    Hi All,

    I am siply loading and updating data from one table to another.But data is huge and number of column are also high. So i want to drop index initially and once data is loaded then i need create index on that table. In the target table there is no primary key.

    How can i aschieve this? please suggest ideas.

    Thanks

    Abhas.

    No magic required:

    1) ExecuteSQL task to drop index.

    2) Dataflow task to load data.

    3) ExecuteSQL task to create index.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • December 10, 2013 at 12:52 am

    #1672218

    Thanks Phil,

    But there is no Primary key in the target table , so can go with non-clustered index or clustered index?

    Thanks

    Abhas.

  • December 10, 2013 at 12:59 am

    #1672220

    abhas (12/10/2013)

    Thanks Phil,

    But there is no Primary key in the target table , so can go with non-clustered index or clustered index?

    Thanks

    Abhas.

    You can either add a primary key (clustered or non-clustered) or just add a non-clustered index.

    It really depends on the data and how the table is going to be queried.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 10, 2013 at 12:59 am

    #1672221

    abhas (12/10/2013)

    Thanks Phil,

    But there is no Primary key in the target table , so can go with non-clustered index or clustered index?

    Thanks

    Abhas.

    Why does the absence of a PK have any bearing on dropping and creating an index? Is there something you are not telling us?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply