[dba-SQLServer] Turn off an index

You'd normally want this to be off when you are updating hundreds of  
records so the db doesn't need to update the row and the index.

Sent from my mobile

On Dec 11, 2009, at 8:18 AM, jwcolby <jwcolby at colbyconsulting.com>  
wrote:

> My DBFH large table never changes, it is read-only.  I create cover  
> indexes for sets of related
> fields used in where clauses.  Why would I turn on / off an index?   
> Is there any advantage to
> leaving an index "turned off" for a read-only file or is this one of  
> those "while you are updating"
> kind of things that I don't need to be concerned about?
>
> -- 
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>