4 ms·
> [...] execution plan is formed by the DB engine before the parameters are even considered Is this really possible if the server considers table statistics (i
by cromd 5y ago
> [...] execution plan is formed by the DB engine before the parameters are even considered
Is this really possible if the server considers table statistics (i.e. frequencies of certain values) when forming a plan?
- thinkharderdev 5y agoTypically the SQL statement will be parsed to a logical plan first, which then gets optimized and then turned into a physical execution plan. Statistics are used for a second layer of optimization on the physical execution plan.