explainplanforselectCFG_ID,COUNT(0)total

fromLOG_FD_VIDEO_SAMPLEa

where1=1

andSERVICE_TYPE=35

andFOUND_TIME>=

to_date('2014-07-0800:00:00','yyyy-MM-ddHH24:mi:ss')

andFOUND_TIME<=

to_date('2014-07-0816:00:00','yyyy-MM-ddHH24:mi:ss')

AND(cfg_idin

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

GROUPBYCFG_ID;


查询执行顺序结果

select*fromtable(DBMS_XPLAN.display);


这个说明执行的是查询索引。