GENERAL INFORMATION
Activity start : 01-DEC-2020 00:00:00
Activity end : 02-DEC-2020 00:00:00
Executions completed : 93
Executions interrupted : 0
Executions with fatal error : 0

SUMMARY (AUTO INDEXES)
Index candidates : 1
Indexes created (visible / invisible) : 1 (1 / 0)
Space used (visible / invisible) : 11.53_MB (11.53_MB / 0_B)
Indexes dropped : 0
SQL statements verified : 4
SQL statements improved (improvement factor) : 3 (7716x)
SQL plan baselines created : 0
Overall improvement factor : 5788x

SUMMARY (MANUAL INDEXES)
Unused indexes : 0
Space used : 0_B
Unusable indexes : 0

INDEX DETAILS
1. The following indexes were created:
*: invisible
Owner Table Index Key Type Properties
TEST1 TAB_TEST1_AUTOIDX SYS_AI_85xrrw9rhauv0 OWNER B-TREE NONE

VERIFICATION DETAILS
1. The performance of the following statements improved:
Parsing Schema Name : TEST1
SQL ID : 36wb4kunddx0n
SQL Text : SELECT * FROM test1.tab_test1_autoidx WHERE owner='DBSNMP'
Improvement Factor : 368x

Execution Statistics:
Original Plan
Auto Index Plan
Elapsed Time (s): 11355 90121
CPU Time (s): 10292 6451
Buffer Gets: 736 26
Optimizer Cost: 397 18
Disk Reads: 0 23
Direct Writes: 0 0
Rows Processed: 100 472
Executions: 2 1


PLANS SECTION

- Original
Plan Hash Value : 4025206578

Id Operation Name Rows Bytes Cost Time
0 SELECT STATEMENT 397
1 . TABLE ACCESS FULL TAB_TEST1_AUTOIDX 2931 386892 397 00:00:01

Notes
- optimizer_use_stats_on_conventional_dml = yes


- With Auto Indexes
Plan Hash Value : 3899752344

Id Operation Name Rows Bytes Cost Time
0 SELECT STATEMENT 472 62304 18 00:00:01
1 . TABLE ACCESS BY INDEX ROWID BATCHED TAB_TEST1_AUTOIDX 472 62304 18 00:00:01
* 2 .. INDEX RANGE SCAN SYS_AI_85xrrw9rhauv0 472 4 00:00:01

Predicate Information (identified by operation id):

Notes
- Dynamic sampling used for this statement ( level = 11 )

Parsing Schema Name : TEST1
SQL ID : 376k3th4ukx5v
SQL Text : SELECT COUNT(*) FROM TEST1.TAB_TEST1_AUTOIDX WHERE OWNER='DBSNMP'
Improvement Factor : 11390x

Execution Statistics:
Original Plan
Auto Index Plan
Elapsed Time (s): 61222456 321
CPU Time (s): 59816808 320
Buffer Gets: 11390000 4
Optimizer Cost: 3303 4
Disk Reads: 0 0
Direct Writes: 0 0
Rows Processed: 1000 1
Executions: 1000 1


PLANS SECTION

- Original
Plan Hash Value : 1334537939

Id Operation Name Rows Bytes Cost Time
0 SELECT STATEMENT 3303
1 . SORT AGGREGATE 1 66
2 .. TABLE ACCESS FULL TAB_TEST1_AUTOIDX 23450 1547700 3303 00:00:01

Notes
- optimizer_use_stats_on_conventional_dml = yes


- With Auto Indexes
Plan Hash Value : 685039912

Id Operation Name Rows Bytes Cost Time
0 SELECT STATEMENT 1 5 4 00:00:01
1 . SORT AGGREGATE 1 5
* 2 .. INDEX RANGE SCAN SYS_AI_85xrrw9rhauv0 472 2360 4 00:00:01

Predicate Information (identified by operation id):

Notes
- Dynamic sampling used for this statement ( level = 11 )

Parsing Schema Name : TEST1
SQL ID : fbupu9qujb5xw
SQL Text : /* SQL Analyze(798,1) */ SELECT COUNT(*) FROM TEST1.TAB_TEST1_AUTOIDX WHERE OWNER='DBSNMP'
Improvement Factor : 11390x

Execution Statistics:
Original Plan
Auto Index Plan
Elapsed Time (s): 799181 213
CPU Time (s): 678770 212
Buffer Gets: 113900 4
Optimizer Cost: 3303 4
Disk Reads: 0 0
Direct Writes: 0 0
Rows Processed: 10 1
Executions: 10 1


PLANS SECTION

- Original
Plan Hash Value : 1334537939

Id Operation Name Rows Bytes Cost Time
0 SELECT STATEMENT 3303
1 . SORT AGGREGATE 1 5
2 .. TABLE ACCESS FULL TAB_TEST1_AUTOIDX 472 2360 3303 00:00:01

- With Auto Indexes
Plan Hash Value : 685039912

Id Operation Name Rows Bytes Cost Time
0 SELECT STATEMENT 1 5 4 00:00:01
1 . SORT AGGREGATE 1 5
* 2 .. INDEX RANGE SCAN SYS_AI_85xrrw9rhauv0 472 2360 4 00:00:01

Predicate Information (identified by operation id):

Notes
- Dynamic sampling used for this statement ( level = 11 )


ERRORS
No errors found.