explain plan.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 16 May 2017 12:25:38 +0300
changeset 2137 81d0f561a4a3
parent 2136 3f34a66e6a2a
child 2138 1130d83b83ae
explain plan.
oracle.rst
--- a/oracle.rst	Tue May 16 12:23:41 2017 +0300
+++ b/oracle.rst	Tue May 16 12:25:38 2017 +0300
@@ -236,12 +236,22 @@
 
   select (*) from ( ... ORIGINAL QUERY ... );
 
+Another option is::
+
+  delete plan_table;
+  explain plan for ... SQL statement ...;
+  select time from plan_table where id = 0;
+
 See:
 
 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm
   $SQL lists statistics on shared SQL area without the GROUP BY clause.
 http://stackoverflow.com/questions/22198853/finding-execution-time-of-query-using-sql-developer
   Finding Execution time of query using SQL Developer.
+http://stackoverflow.com/questions/3559189/oracle-query-execution-time
+  Oracle query execution time.
+http://tkyte.blogspot.com/2007/04/when-explanation-doesn-sound-quite.html
+   When the explanation doesn't sound quite right...
 
 Last table modification time.
 =============================