Sql> Select Count(*) fromemployees; COUNT(*)---------- 107ExecutionPlan----------------------------------------------------------PlanHash value:3580537945-------------------------------------------------------------------------|Id|Operation|Name|Rows|Cost (%CPU)|Time|-------------------------------------------------------------------------| 0 | SELECTSTATEMENT| | 1 | 1(0)| xx:xx: on || 1 |SORT AGGREGATE| | 1 | | || 2 | INDEX FullSCAN|Emp_email_uk| 107 | 1(0)| xx:xx: on |-------------------------------------------------------------------------Statistics---------------------------------------------------------- 224Recursive calls0db block gets theconsistent gets1Physical reads0Redo Size527Bytes sent via SQL*Net toClient523Bytes received via SQL*Net fromClient2Sql*Net roundtrips to/ fromClient6sorts (memory)0Sorts (Disk) 1Rows processed
"Test" writes an SQL statement using the Employees table under the HR user, performs a scheduled walk index full scan