Loading...

Oracle High Availability, Disaster Recovery, and Cloud Services by Y V Ravi Kumar & Nassyam Basha & Krishna Kumar K M & Bal Mukund Sharma & Konstantin Kerekovski

Oracle High Availability, Disaster Recovery, and Cloud Services by Y V Ravi Kumar & Nassyam Basha & Krishna Kumar K M & Bal Mukund Sharma & Konstantin Kerekovski

Author:Y V Ravi Kumar & Nassyam Basha & Krishna Kumar K M & Bal Mukund Sharma & Konstantin Kerekovski
Language: eng
Format: epub
ISBN: 9781484243510
Publisher: Apress


EMPLOYEE_ID FIRST_NAME LAST_NAME PHONE_NUMBER

----------- -------------------- ------------------------- ------------

185 Alexis Bull 650.509.2876

SQL> select * from table(dbms_xplan.display_cursor());

SQL_ID 6h7jvaqfuycvj, child number 0

-------------------------------------

select employee_id, first_name, last_name, phone_number from

hr.employees where first_name = 'Alexis'

Plan hash value: 612698390

---------------------------------------------------------------------------

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |

--------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | | | 2 (100) | |

| 1 | TABLE ACCESS BY INDEX ROWID BATCHED | EMPLOYEES | 1 | 34 | 2 (0) | 00:00:01|

|* 2 | INDEX SKIP SCAN | EMP_NAME_IX | 1 | | 1 (0) | 00:00:01|

--------------------------------------------------------------------------------



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.