Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
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.

 

Thanks.

 

Ted Sturr

Palomar Medical 

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

Re: SalesLogix indexes

Nope.. don't bother.
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
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 !

 

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