Adding your own Datamart indexes

Adding your own Datamart indexes

With informXL Datamart  you can add your own database indexes. This can be super helpful in resolving slow to run 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, and not on tables. 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.

indexing_views

in informXL Datamart