Tuesday, 22 October 2013

Supporting additional mart indices for performance tuning

Mart maintenance can be used for creating (or maintaining) indices. Handy way to do performance tuning sometimes.

This mart has no index other than the primary key index.

.


.
We write the mart maintenance script.


.

Register this script.




.

The new index is created.
.



In appstore environments, the "Apply to Subscribers" checkbox can be checked so that app subscribers also get this index.

1 comment: