Re: Any better plan for this query?..

Simon Riggs <simon@2ndQuadrant.com> writes:
> In particular, running the tests repeatedly using
>     H.REF_OBJECT = '0000000001'
> rather than varying the value seems likely to benefit MySQL.

... mumble ... query cache?

            regards, tom lane