Is using joins in select clause slow in Oracle?
- by gniquil
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?