> > CREATE INDEX myMyIndex ON myTable (myKey); > > CREATE UNIQUE INDEX [pkPrimary] ON [myTable] ([myKey], [NumOne]); > > CREATE INDEX myNumOneIndex ON myTable (NumOne); > > Why did you chose these indexes? > Updates and Inserts are faster with fewer indices. > Perhaps they can be reduces? > > You do have a rather large database, you'll have to be pretty > aggressive to get good performance from it.
Yeah, originally there was (and should be) only the one UNIQUE index. I added the other two during a test and when someone here asked about the schema they were still in They have been dropped now, and the single unique index is the only one remaining. It is about the bare minimum I think I can get away with
