SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 14611: Performance improvement by adding indexes to SAS Human Capital Management tables

DetailsHotfixAboutRate It
In SAS Human Capital Management 3.1 (HCM, HRV, HR Vision) many of the
tables in the data warehouse have indexes added to them.  These indexes
improve the performance when accessing the data in these tables.

With the release of SAS Human Capital Management 3.1.0.5, the process of
adding indexes to these tables is improved which results in faster
refresh times for the tables with indexes.

A fix for this issue is available at:

http://www.sas.com/techsup/download/hotfix/hr_vision31.html#014611


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Human Capital ManagementMicrosoft Windows 2000 Professional3.1
Microsoft Windows NT Workstation3.1
HP-UX3.1
64-bit Enabled Solaris3.1
Solaris3.1
64-bit Enabled HP-UX3.1
AIX3.1
64-bit Enabled AIX3.1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.