Yes. Duplicate indexes are not needed.
> -----Original Message-----
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 29, 2002 5:55 PM
> To: CF-Talk
> 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
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists