Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dropping Indexes after comparing Index Definition Expand / Collapse
Author
Message
Posted Monday, April 15, 2013 5:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 4, 2013 11:39 PM
Points: 50, Visits: 149
Hello,

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??

Thanks
Manissha

Post #1442260
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse