equal
deleted
inserted
replaced
234 Alternatively you may wrap you query with (and optionally use hint to disable |
234 Alternatively you may wrap you query with (and optionally use hint to disable |
235 optimizations??):: |
235 optimizations??):: |
236 |
236 |
237 select (*) from ( ... ORIGINAL QUERY ... ); |
237 select (*) from ( ... ORIGINAL QUERY ... ); |
238 |
238 |
|
239 Another option is:: |
|
240 |
|
241 delete plan_table; |
|
242 explain plan for ... SQL statement ...; |
|
243 select time from plan_table where id = 0; |
|
244 |
239 See: |
245 See: |
240 |
246 |
241 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm |
247 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm |
242 $SQL lists statistics on shared SQL area without the GROUP BY clause. |
248 $SQL lists statistics on shared SQL area without the GROUP BY clause. |
243 http://stackoverflow.com/questions/22198853/finding-execution-time-of-query-using-sql-developer |
249 http://stackoverflow.com/questions/22198853/finding-execution-time-of-query-using-sql-developer |
244 Finding Execution time of query using SQL Developer. |
250 Finding Execution time of query using SQL Developer. |
|
251 http://stackoverflow.com/questions/3559189/oracle-query-execution-time |
|
252 Oracle query execution time. |
|
253 http://tkyte.blogspot.com/2007/04/when-explanation-doesn-sound-quite.html |
|
254 When the explanation doesn't sound quite right... |
245 |
255 |
246 Last table modification time. |
256 Last table modification time. |
247 ============================= |
257 ============================= |
248 :: |
258 :: |
249 |
259 |