drop and create INDEX in ETL

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  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.

• Phil Parkin

  SSC Guru

  Points: 246686

  More actions

  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.

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  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.

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 246686

  More actions

  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?

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.