Why does this plan make sense?

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?

optimizer

asked 22 Jul '11, 10:32

Martin
9.1k●131●170●257
accept rate: 14%

flat view

Be the first one to answer this question!

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

question asked: 22 Jul '11, 10:32

question was seen: 1,492 times

last updated: 22 Jul '11, 10:32

SAP SQL Anywhere