04-13-2009 01:58 PM
Thanks to a great posting by empath-e on optimizing indexes within databases that have been upgarded from previous versions I started looking through our own indexes since they have grown out of a 5.x database. In rebuilding indexes I saw that Sage's approved index script "Sample MSSQL Indexes" calls for indexing the alternatekeysuffix and alternatekeyprefix fields in the Account and Contact table. But in my database and I assume all other databases these fields are blank. Is there a reason that they are adding an index for these non-used fields?
Solved! Go to Solution.
04-13-2009 02:54 PM
04-13-2009 04:21 PM - edited 04-13-2009 04:23 PM
Thanks for your comments. No, these are "throw-backs" from the old Opis system. I don't recommend adding them - no need !
PS If anyone else needs this - it's here:
Generally, other useful stuff here too!