Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Copper Contributor
Posts: 28
Registered: ‎04-01-2009
Accepted Solution

SalesLogix indexes

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.




Ted Sturr

Palomar Medical 

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: SalesLogix indexes

Nope.. don't bother.
RJ Ledger - +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..." - blog:
Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

Re: SalesLogix indexes

[ Edited ]

Hi Tedd


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!


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