List out from below what can be done for query optimization?

 Posted by Rajnilari2015 on 11/28/2015 | Category: Oracle Interview questions | Views: 1740 | Points: 40
Select from following answers:
  1. Use EXISTS instead of IN clause since EXISTS is faster than IN Clause
  2. Use UNION ALL in place of UNION
  3. Avoid * in SELECT statement
  4. Try to maintain as small clustered index as much as possible
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response