SQLTeam.com | Weblogs | Forums

isp_ALTER_INDEX how to skip particular tables with columnstore index


#1

Hi We are using the isp_Alter_Index script by Tara. Is there a latest edition available which accepts columnstore index. Columnstore index has been added and the re indexing job is failing.

Is it possible to ignore the columnstore index?


#2

I think you'll need to script out the ALTER INDEX commands and remove the one causing you problems. Alternatively, maybe you can hack the script? Third option, consider Minion Reindex -- very configurable