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.

8 comments:


  1. It was so good to read and useful to improve my knowledge as updated one.Thanks to Sharing.
    ETL Testing Online Training
    Hadoop online Training
    Informatica Online Training

    ReplyDelete
  2. Hi! The post you published is well-written and informative. It has more topic discussions which i want really. So helpful to me. Keep updating.
    Pyhton Training in Chennai
    Python Course in Chennai
    AWS Training in Chennai
    CCNA Training in Chennai
    German Language Course in Chennai
    German Courses in Chennai

    ReplyDelete