Shulou(Shulou.com)06/01 Report--

There are many execution of SQL statements to get oracle, such as using plsql to press F5, using 10046trace, using set autotrace on, and so on to view the execution plan of SQL statements. Looking at the execution plan of the SQL statement in this way will get more detailed information.

The process is as follows:

1. Execute alter session set statistics_level=all

two。 Execute the SQL statement:

Select *

From (select / * + gather_plan_statistics test1 * / *

From test this_

Where this_.LOLTRANSDATE > = '2018-12-10'

And this_.LOLTRANSDATE

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.