返回
-
标题
Can SQL Optimizer combine similar SQL into one better performing query? -
说明
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?
-
原因
SQL optimizer takes only one SQL statement for optimizing. It does not know other ones.
-
解决办法
ANSWER:
No. There is no combination of SQL statements.