Using 5.0.51, I have a fairly substantial SELECT ... GROUP BY query to
which I have added the "SQL_BIG_RESULT" hint.
According to the 5.0 SELECT manual,
"SQL_BIG_RESULT can be used with GROUP BY or DISTINCT to tell the
optimizer that the result set has many rows. In this case,
Yemi Obembe wrote:
learnt SQL_BIG_RESULT in the select syntax builds a temporary table
on the result (if I'm right). What will the Select statement to
access such temporary table look like?
This is an internal temporary table, the result is returned in the
normal way, and the temporary tab
learnt SQL_BIG_RESULT in the select syntax builds a temporary table on the
result (if I'm right). What will the Select statement to access such temporary
table look like?
-
A passion till tomorrow,
Opeyemi Obembe | ng.claw
