Should all tables have a clustered index when a SQL Server database is used?
Clustered indexes may improve performance on SQL Server databases.
All MAXIMO tables which have a unique index should also have a clustered index. This would constitute the rule of thumb for selecting the objects that may have a clustered index applied.
The index that would be clustered on each table would, by default be the primarykey index (defined by the primarykeycolseq column in the MAXATTRIBUTE table).
This can be achieved by setting MAXSYSINDEXES.CLUSTERRULE to 1, however prior to applying any such settings, a full database backup must be considered.
|Systems and Asset Management||IBM SmartCloud Control Desk||Windows 2003 server, Windows 2008 server, Windows 2012 server||7.5, 7.5.1||All Editions|
|Systems and Asset Management||Tivoli Service Request Manager||Windows 2003 server, Windows 2008 server||7.1, 7.1.2, 7.2, 7.2.1, 7.5||All Editions|
|Systems and Asset Management||Tivoli Change and Configuration Management Database|
|Systems and Asset Management||Tivoli Asset Management for IT|