Home Forums Data Warehousing Integration Services Loading to table with clustered PK / Order by in source RE: Loading to table with clustered PK / Order by in source

  • March 26, 2015 at 2:24 pm

    #1786686

    Phil Parkin (3/25/2015)

    Here's a question which I feel like I should know the answer to.

    If I'm using SSIS to load a table with a clustered PK, will the data load faster if the source has been sorted to match the target's clustered PK?

    I don't think it will necessarily load faster, because (imo) the query engine will still include a sort operation in the execution plan of the insert. I do think it could help reduce index fragmentation though.

    Would be an interesting scenario to put to the test...