Is using joins in select clause slow in Oracle?
Posted
by gniquil
on Stack Overflow
See other posts from Stack Overflow
or by gniquil
Published on 2010-05-22T02:38:31Z
Indexed on
2010/05/22
2:40 UTC
Read the original article
Hit count: 209
I would like to write a query like the following
select
username,
(select state from addresses where addresses.username = users.username) email
from users
This works in Oracle (assuming the result from the inner query is unique). However, is there a performance penalty associated with this style of writing query?
© Stack Overflow or respective owner
