which is better table in the join or table in subquery
I Have inquiry about which is more faster and better
to add a table in from clause and join it with the other tables
or
to add the table in sub query
Note that i don't need to select any column from the table i just want to check a parameter value
Here is the 2 queries:
the bold blue text is the difference between the 2 SQL
--No.1 ----
select
initcap(x_header.EVENT_TYPE_CODE) type_indicator,
-- 'Apply/u PrePayement' type_indicator,
to_char(inv.invoice_num) invoice_or_check_number,
x_header.ACCOUNTING_DATE AS_GL_date,