Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    17

    Unanswered: SQL query execution order

    Hi all
    Please tell me the order in which the clauses of the following query will be executed?
    Query :- select table1.column1, table2.column1 from table1 inner join table2 on table1.column1=table2.column1 where table1.column1='Test';

    Clauses to be checked :- 1. inner join 2.Where

    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by TestOracle
    Hi all
    Please tell me the order in which the clauses of the following query will be executed?
    Query :- select table1.column1, table2.column1 from table1 inner join table2 on table1.column1=table2.column1 where table1.column1='Test';
    In whatever order the optimizer thinks is the quickest.
    For details on how it does that, check the manual

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •