DECLARE @prefix varchar(255);
SET @prefix='';		--如有表名前缀，请在这里设置

EXEC ('DROP INDEX ' +@prefix+ 'main.IX_lastupdated');
EXEC ('CREATE INDEX IX_main ON ' +@prefix+ 'main(parent_id ASC, lastupdated DESC, id DESC, guestflag ASC)');