Subject HDR and Joins
Author Christian G├╝tter
Hi,

I need a little confirmation on a HDR issue.
AFAIK, Horizontal Dataset Refinement does not work on fields that are
queried by a join. Is that correct?

Example:
SELECT T1.ID,
T1.Bla,
T2.Blubb
FROM Table1 T1
LEFT OUTER JOIN Table2 T2 ON (T2.ID = T1.Foreign)

In this case, ID is the primary key of the two tables.
Using HDR with column T1.Bla works lightning fast, but
using column T2.Blubb is horribly slow.
So I concluded that HDR does not work with joins.
Is my conclusion correct?
And if it is not, how can I use HDR on the joined column?


Thanks in advance for you answers,


Christian