Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
silas2
Yak Posting Veteran
65 Posts |
 Posted - 2005-08-23 : 08:15:25
|
| I've just started looking at how the Access 2k Upsizing tool is creating indexes in the corresponding upsized SQL Server tables. It seems to create multiple indexes for the same field, I think adding an extra index for a relationship, i.e.Say Contracts-Sites tables have relationship Contracts.SiteID==Sites.SiteID then the indexes created on the Contracts table are:index_name = "SiteID", index_keys = "SiteID"index_name = "SitesContracts", index_keys = "SiteID"What is the point of having two indexes on the same field? Should I be manually (what a job!) getting rid the extras? Does maintaing these extra indexes impinge in performance? |
|
|
|
|
|
Upsizing Tool-Indexes