IT'S ALL ABOUT THE DATA.
 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

By

  • 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…