Where is the latest information on custom tuning indexes for performance?


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.

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s