On Fri, May 30, 2008 at 10:49:21AM +0200, Peter Vanderborght wrote: > What can I do to tell the optimizer to keep its hands off my query or at > least get it to not optimize?
The usual trick is you put an OFFSET 0 in the subquery, which prevents the optimiser from pulling it up. Have a nice day. -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature