Restituisci
-
Titolo
Can SQL Optimizer combine similar SQL into one better performing query? -
Descrizione
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?
-
Causa
SQL optimizer takes only one SQL statement for optimizing. It does not know other ones.
-
Risoluzione
ANSWER:
No. There is no combination of SQL statements.