[dba-SQLServer] Adding indexes programmatically

John W. Colby jwcolby at colbyconsulting.com
Sat Dec 11 23:34:36 CST 2004


Does anyone have code to add indexes to every field in a table?  I am
breaking the nVLDB table down into subsets of related fields in smaller
tables and need to index each field.  The PK field is just that, an integer
and unique.  The rest are just text fields and non-unique.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/





More information about the dba-SQLServer mailing list