top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: What are the Limitations of sub query?

+1 vote
Oracle: What are the Limitations of sub query?
posted Aug 17, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

When subquery is used, the database server (actually the query optimizer) may need to perform additional steps, such as sorting, before the results from the subquery are used. If a query that contains subqueries can be rewritten as a join, you should use join rather than subqueries. This is because using join typically allows the query optimizer to retrieve data in the most efficient way.

In other words, The optimizer is more mature for MySQL for joins than for subqueries, so in many cases a statement that uses a subquery can be executed more efficiently if you rewrite it as a join.

answer Aug 18, 2015 by Manikandan J