Re: enabling join_collapse_limit for a single query only

groovefillet wrote:
> Is it possible to set the runtime parameter 'join_collapse_limit' for
> a single query only without setting/unsetting it before/after?

Yes:

START TRANSACTION;

SET LOCAL join_collapse_limit = 42;

SELECT .....

COMMIT;

Yours,
Laurenz Albe