-
Sreeharsha Ramanavarapu authored
DELETE STATEMENT Issue: ------ In case of an UPDATE/DELETE statement with an ORDER BY ... LIMIT, table scan is used. When the optimizer tries to check if there is a cheaper ordering compared to filesort, some checks are missing. Solution: --------- Use the table object instead of the JOIN_TAB object.
Sreeharsha Ramanavarapu authoredDELETE STATEMENT Issue: ------ In case of an UPDATE/DELETE statement with an ORDER BY ... LIMIT, table scan is used. When the optimizer tries to check if there is a cheaper ordering compared to filesort, some checks are missing. Solution: --------- Use the table object instead of the JOIN_TAB object.
Loading