I need to update all the indexes in my database through C# installer. I am using below queries to drop each index and then recreate them.
if exists (select * from sysindexes where name='IX_Oetype')
DROP INDEX orderlines.IX_Oetype
But it is taking too much time to update the indexes.
Is there is any other query by which I can compare if any change in index definition [ Sequence of columns changed, new column added ...etc] then update else not.
or any other suggestion??