Is the Plan() function returning the result based on Optimizer estimates only? Is Plan() already executing the statement to gather the statistics?
asked 08 Apr '11, 09:26
Martin 8.9k●127●164●253 accept rate: 14%
Yes, Martin - if you use the PLAN() or EXPLANATION() functions, only optimizer estimates are included in the details for any specific plan operator.
answered 10 Apr '11, 08:33
Glenn Paulley 10.8k●5●76●106 accept rate: 43%
Once you sign in you will be able to subscribe for any updates here
Answers
Answers and Comments
Markdown Basics
learn more about Markdown
Question tags:
select ×67 optimizer ×27 statistics ×14
question asked: 08 Apr '11, 09:26
question was seen: 1,670 times
last updated: 10 Apr '11, 08:33
Low Performance, because statistics aren't used with curent date, current timestamp
Has Create Statistics any effect for varchar columns?
What causes Data Loss when Selecting Data from Sql Anywhere Proxy Tables?
Parallel table scans and VMWare
table description as result set
Is there a more elegant way to obtain the least of 3 dates?
Select command with 32 UNION ALLs crashs the Android application
Reusing of query plans
IN search condition - expression-list represented by a variable
dbvalid error -300 / index not match with table / rowcount
First time here? Check out the FAQ!