Question 114:
As the queries are submitted, a dedicated SQL pool query optimizer attempts to check which Data access paths will result in the minimum amount of effort to get the data needed to resolve the query. This cost-based optimizer will compare the cost of different query plans, and will then select the plan that has the minimum cost. Statistics in a serverless SQL pool have the same aim of utilizing a cost-based optimizer to select a plan with the fastest execution. The thing is that how it generates the statistics is different. Statement: In a serverless SQL pool, if statistics are missing, the query optimizer creates statistics on the whole tables in the query predicate or join condition to enhance the cardinality estimates for the query plan. Select whether the statement is true or false.
Answer options:
A.True B.False