Switch out data from partition table to non-partition table

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  July 18, 2017 at 12:53 pm

  #338356

  Hi Everyone,

  We have a partition table in SQL SERVER 2014 and we want to switch out a partition of this table to a temporary table on the same file group. I read lots of article, that we should have the same non-clustered on temporary table.

  But when I switched out the data without creating those non-clustered indexes  I did not face any problem.So Can we say that creating non-clustered index on temporary table is not required and we just need to create the clustered index on staging table?

  Thanks