|List:||General Discussion||« Previous MessageNext Message »|
|From:||BAUMEISTER Alexandre||Date:||March 10 2000 6:05pm|
|Subject:||Re: Locked tables while "Sending data" !?|
|View as plain text|
Salut, TB> And can you say what the cheapest way to force the use of a TB> temporary table is? (Using ORDER BY would be too expensive.) TB> Would a "HAVING 1=1", without a GROUP BY, work or would it be TB> optimised away? I tried with an ORDER BY on one of the columns and the result was exactly the same. Writers on the table where locked while the "Sending data" ! Why ? Alex.