[dba-SQLServer] Turn off an index

Thanks Francisco, that's what I thought.  Not applicable to me.

John W. Colby
www.ColbyConsulting.com


Francisco Tapia wrote:
> 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
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>