08-02-2013 03:50 PM
I have added some custom tables.
After doing some performance analysis it was revealed that these custom tables (Created with Database Manager) do not a have a "Primary Key" and unique clustered index in SQL server.
Is it permissable to set the Primary key and create the unique clustered index using SQL Management Studio?
The Primary Key was identified as such when creating the table and functions correctly in all sales logix applications. It just not performing as good as it can from a SQL Server stand point.
Current SQL Server is SQL Server 2005 SP3
Is SQL Server 2012 supported by SalesLogix 7.5.4 and up?
08-03-2013 02:33 AM - edited 08-03-2013 02:34 AM
It only depends if you have remotes.
If you do not - then what you wish to do is absolutely fine. SLX does not store anything about indexes - it queries the DB for these at runtime.
It would not have any idea about funky compound keys etc. but those will be used by SQL in any event.
If you have remotes, just bear in mind what you do in Studio will not go to the remotes until they are rebuilt.
SQL2012 is not supported (but works, uncertified) until v8.
More info on indexes (quite old, but still relevant, now) here: http://www.empath-e.com/documents/Bulletins/090319-IndexUtilisation.pdf