AutoTrace in sql Developer

Viewed 15158

What is the basic difference between EXPLAIN PLAN and AUTOTRACE in SQL Developer. Can anybody please elaborate?

This is the query on which I am trying to get the difference inbetween Autotrace and Explain Plan.

SELECT name, address, latest_in
  FROM ( SELECT name, address, latest_in
         ROW_NUMBER() OVER (PARTITION BY name ORDER BY address DESC) AS rowrank    
         FROM avrajit
       )
  WHERE rowrank <> 1 AND rowrank > 3;
1 Answers
Related