Heap organized, index on person_id ======================================================================== Plan hash value: 1601196873 -------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 215 | 6235 | 75 (3)| 00:00:01 | |* 1 | TABLE ACCESS FULL| T | 215 | 6235 | 75 (3)| 00:00:01 | -------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("PERSON_ID"=221) 0.00441813468933105 seconds 0.0030820369720459 seconds 0.00295114517211914 seconds 0.00275802612304688 seconds 0.00286698341369629 seconds Heap organized, index on person_id, doc_name ======================================================================== Plan hash value: 4063441116 ----------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 215 | 6235 | 3 (0)| 00:00:01 | |* 1 | INDEX RANGE SCAN| IX_T_PERSON_ID | 215 | 6235 | 3 (0)| 00:00:01 | ----------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - access("PERSON_ID"=221) 0.00239396095275879 seconds 0.00151991844177246 seconds 0.00149106979370117 seconds 0.0014798641204834 seconds 0.00148296356201172 seconds Heap organized, bitmap index on person_id ======================================================================== Plan hash value: 1206603653 ----------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 215 | 6235 | 40 (0)| 00:00:01 | | 1 | TABLE ACCESS BY INDEX ROWID | T | 215 | 6235 | 40 (0)| 00:00:01 | | 2 | BITMAP CONVERSION TO ROWIDS| | | | | | |* 3 | BITMAP INDEX SINGLE VALUE | IX_T_PERSON_ID | | | | | ----------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 3 - access("PERSON_ID"=221) 0.00265598297119141 seconds 0.00163793563842773 seconds 0.00156593322753906 seconds 0.00157809257507324 seconds 0.00160694122314453 seconds Index organized on person_id, doc_id ======================================================================== Plan hash value: 921704771 ------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 215 | 6235 | 4 (0)| 00:00:01 | |* 1 | INDEX RANGE SCAN| T_PK | 215 | 6235 | 4 (0)| 00:00:01 | ------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - access("PERSON_ID"=221) 0.00234603881835938 seconds 0.00153303146362305 seconds 0.00147080421447754 seconds 0.00147485733032227 seconds 0.00147104263305664 seconds Index organized on person_id, doc_id; compressed ======================================================================== Plan hash value: 921704771 ------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 215 | 6235 | 3 (0)| 00:00:01 | |* 1 | INDEX RANGE SCAN| T_PK | 215 | 6235 | 3 (0)| 00:00:01 | ------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - access("PERSON_ID"=221) 0.00233793258666992 seconds 0.00151801109313965 seconds 0.00148701667785645 seconds 0.0012660026550293 seconds 0.00148105621337891 seconds Single table cluster hashkeys 16 ======================================================================== Plan hash value: 2719348108 --------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| --------------------------------------------------------------- | 0 | SELECT STATEMENT | | 215 | 6235 | 0 (0)| |* 1 | TABLE ACCESS HASH| T | 215 | 6235 | | --------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - access("PERSON_ID"=221) 0.00250101089477539 seconds 0.00164103507995605 seconds 0.00161910057067871 seconds 0.00159287452697754 seconds 0.00160908699035645 seconds