SalesLogix indexes

[TSturr]

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?

Just curious.

Thanks.

Ted Sturr

Palomar Medical 

[RJLedger · Accepted solution]

Nope.. don't bother.

[MikeSpragg]

Hi Tedd

Thanks for your comments. No, these are "throw-backs" from the old Opis system. I don't recommend adding them - no need !

Regards

Mike

PS If anyone else needs this - it's here:

http://www.empath-e.com/documents/Bulletins/090319-IndexUtilisation.pdf

Generally, other useful stuff here too!

http://www.empath-e.com/Support/resources

Message Edited by MikeSpragg on 04-14-2009 12:23 AM