Querying the Order of Oracle execution

explain Plan  for Selectcfg_id,COUNT(0) Total

from

 

and service_type =

and found_time >=

' 2014-07-08 00:00:00 '

and

' 2014-07-08 16:00:00 '

and (cfg_id in

       (' 30811 ', ' 30812 ', ' 30813 ', ' 30814 ', ' 30815 ', ' 30816 ', ' 30817 '))

GROUP by cfg_id;

Query Execution Order Results

SELECT * FROM table (dbms_xplan.display);

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/3A/7F/wKiom1O7veCywvSeAALcXRyGlJI634.jpg "title=" Picture 1.png "alt=" Wkiom1o7vecywvseaalcxryglji634.jpg "/>

This description executes the query index.

This article is from the "Little West" blog, please be sure to keep this source http://gggcgba.blog.51cto.com/3889163/1436011