Subject Embedded SELECT
Author Alexander Tabakov
Hi All,

In a database we have some tables which contain look-up values.

When performing a query it is much slower to include these tables in
the join and select the values than to make an embedded select like

(select some_value from tbl_look_up where value_id = other_table.value_id)
other_table join ....

Timing is something like 3s vs 0.6s for one of the queries

Note:I am not sure if this is called "embedded select" by the way.
Correct me if needed.

Any ideas? Generally when is better to perform an embedded select?

Best regards,
Alexander mailto:saho@...