Column Store Index Refresh

• sudhirnune

  SSCrazy

  Points: 2342

  More actions

  August 20, 2015 at 3:52 am

  #398927

  Hi All,

  When we use Partition switch and load the data to a table, can we refresh the indexes for specific partition, so that we don't need to rebuild / refresh for complete is this possible ?

  Is there any suggestions ?

• s_osborne2

  SSCertifiable

  Points: 6726

  More actions

  August 20, 2015 at 4:48 am

  #1821325

  Hi,

  This documentation relating to SQL Server 2014 seems to suggest you can specify a partition.

  https://msdn.microsoft.com/en-us/library/dn589807(v=sql.120).aspx#rebuild

  Thanks,

  Simon

  ---

  
  MCSE: Data Platform
  MCSE: Business Intelligence
  Follow me on Twitter: @WazzTheBadger
  LinkedIn Profile: Simon Osborne