Bud,
It depends on if the category_id is a field that is searched alot. If that is the case, you might as well leave that index as it will help performance. If not, then deleting it will harm nothing... Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 4:54 PM Subject: OT: SQL Server Indexes > Hi all. I've noticed when upsizing an Access database, I'll get > duplicate indexes on the primary keys. For instance, if I have a > Category_ID field which is the primary key and indexed in Access, > after upsizing, I'll get an index named aaaaaCategory_ID_PK and also > one named Category_ID in the SQL DB. Should I delete the Category_ID > index? It seems redundant. > > Thanks. > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
