A Faster Way of Joining When Applying a Distinct

You may also like...

3 Responses

  1. Elwin Harrison says:

    I wonder what it would look like on z/OS. I learned a few new tricks from this blog that I would like to get a chance to try out on z/OS. Keep writing these kinds of interesting blogs because most people are still trying to write SQL with what was available in DB2 V6.

  2. A bit late to the party, but internet searches let us find these gems 🙂

    Did you consider using an MQT enabled for query optimisation?

    Another alternative might be a statistical view.

    If we can use either MQTs and/or statistical views then it may be possible to enhance an application to which we don’t have access to change the SQL.

    Regards
    Rob

Leave a Reply

Your email address will not be published. Required fields are marked *