Return
-
Title
Can SQL Optimizer combine similar SQL into one better performing query? -
Description
User had seven similar sql statements that he wanted optimizer to evaluate and recommend sql changes. All return two values (group by and type), just different counts like (active, closed, old, open, etc.)
Can SQL Optimzer perform that function?
-
Cause
SQL optimizer takes only one SQL statement for optimizing. It does not know other ones.
-
Resolution
ANSWER:
No. There is no combination of SQL statements.