This wiki details custom tuning indexes that are the result of iterative performance tuning cycles and collaboration with the TRIRIGA development team. The indexes listed here are not included in the TRIRIGA base product unless otherwise stated. These indexes, which are listed by database platform, provide significant performance improvements when measured against a broad performance test workload.
While TRIRIGA recommends adding these indexes per their respective database platform, performance gains may vary depending on an array of factors including application usage, load patterns, hardware sizing, application and database server configuration and so on. Database Administrators should monitor databases for efficient index usage and determine the overall impact produced by applying the custom indexes provided here and to determine additional indexes that will improve performance based on situational and data composition needs.