Follow us on Twitter! Add us on Facebook! Add our RSS feed!

How to Improve Performance in Warehouse Systems Using Replicated MQTs

Simple steps for substantially reducing execution time


  • Fanche

    Excellent article indeed. Dou you have any feedback of that tunning tip in an SAP BW environnement ? What we observe in the DB2 DPF behind our SAP BW (Finance) looks very much alike your exemple. But SAP does not seem to support MQTs, thus my question…Regards

  • Nishant

    Excellent work on Replicated MQT! The second workaround to improve performance was really good. I wish optimizer could pick MQTs from different partition groups.

  • Girish

    Fantastic article and a wonderful way of making use of two database partition groups along with MQT. Very well done, keep it up!!

  • Nishant

    Excellent! Very well explained and other DBAs can use this information in their DPF environments. Good work done!

    • mrinal

      Nice One…