Oracle SQL Performance Tuning Tips- Using Joints in Place of EXISTS for Unique Scan Indexes and small tables a to z help

Oracle SQL Performance Tuning Tips- Using Joints in Place of EXISTS for Unique Scan Indexes and small tables a to z help

•In general join tables rather than specifying sub-queries for them such as the following:

 

   select acct_ID, currency, branch

  from account

  where exists (select 1 from branch

   where code = branch and def_curr  = '001')

• With join -

 

  select acct_ID,currency, branch

  from account A, branch B

  where b.code = A.branch

  and A.def_curr  = '001'

Note : Provide your comments by clicking below options! Thanks ! :)

Tweet