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
this:

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

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@...