Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS Owner Table Index Key Type Properties HR DEPARTMENTS SYS_ AI_ 0urcv8chmxu20 LOCATION_ ID B TREE NONE HR LOCATIONS SYS_ AI_ 1hgrs7xdghs31 CITY B TREE NONE report truncated to save space VERIFICATION DETAILS 1 The performance of the following statements improved Schema Name HR SQL ID 3dfa28psdfe73 SQL Text select from regions where region_ name Europe Improvement Factor 2x PLANS SECTION Original Plan hash value 3077898360 Id Operation Name Rows Bytes Cost CPU Time 0 SELECT STATEMENT 1 14 3 0 00 00 01 1 TABLE ACCESS FULL REGIONS 1 14 3 0 00 00 01 ORACLE MAGAZINE JULY AUGUST 2019 130
You must have JavaScript enabled to view digital editions.