SQL Performance (MOSC)

MOSC Banner

which is better table in the join or table in subquery

edited Dec 19, 2013 3:20AM in SQL Performance (MOSC) 9 commentsAnswered
 Hi Experts,

 

 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,    

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center