[dba-SQLServer] Adding indexes programmatically

Andy Lacey andy at minstersystems.co.uk
Sun Dec 12 04:04:36 CST 2004


Hi John
The BEU has code to add indexes. I'm sure you could adapt that to loop
through Fields.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of John W. Colby
> Sent: 12 December 2004 05:35
> To: SQLServer
> Subject: [dba-SQLServer] Adding indexes programmatically
> 
> 
> 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/
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 




More information about the dba-SQLServer mailing list