>Try this (though it won't work if you disable a clustered index and then try to insert data....so I'd only recommend this for reading data)
>
>
>ALTER INDEX [MyIndex] on [MyTable] DISABLE
> GO
>
>
>ALTER INDEX [MyIndex] on [MyTable] REBUILD
>
> GO
>
>
>I'm not aware of any way to re-enable an index...only way I know is to rebuild it.
This works. However, it will just keep bouncing back on other indexes until I disable them all. Is there a way to disable all the indexes on a table?