I am just curious, I have seen in a plan a sequence like this:
DistH DT DistH
Is any situation possibly in which the upper DistH will result in different entries than the derived table have from the first Hash Distinct?
asked 22 Jul '11, 10:32
Martin 8.9k●127●164●253 accept rate: 14%
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:
optimizer ×27
question asked: 22 Jul '11, 10:32
question was seen: 1,316 times
last updated: 22 Jul '11, 10:32
Reusing of query plans
SQL Query that hangs
Calibration best practices
How to calibrate the IO read speed for the query optimizer?
11.0.1.2405 Indexes not being used - Is this a known Problem?
Has Create Statistics any effect for varchar columns?
Intra-query parallelism
Worser Performance on 2nd call of same Statement
Is a reverse index scan distinquished from an index scan?
Low Performance, because statistics aren't used with curent date, current timestamp
First time here? Check out the FAQ!