Adding your own Datamart indexes

With informXL Datamart, you can add your own Database Indexes.  This can be super helpful in resolving slow running Reports and Queries.

In Datamart, Indexes can be added to Tables and Views.  The suggested best practice is that all Custom Indexes be created on Views.  Each of the standard “dbo” Views within Datamart are delivered as “schema bound” (this allows Indexes to be created on Views in the same way an Indexes would be created on a Table).

NOTE: During a typical informXL Datamart version upgrade, Tables and Views are dropped and recreated.  When this occurs, any Custom Indexes will also be dropped.  It’s important that you keep a copy of your Custom Index Script to apply to the Database following a major update.