---------------------------------------------------------------------------------------------------------------------------+
| Plan signature: 16163664674105152017
=======================================================
|ID|OPERATOR  |NAME                    |EST. ROWS|COST|
-------------------------------------------------------
|0 |TABLE SCAN|assea(sortKey01,Reverse)|10       |132 |
=======================================================

Outputs & filters: 
-------------------------------------
  0 - output([assea.id(0x7fa72fa5eb90)], [assea.first_time(0x7fa72fa5f180)]), filter([(T_OP_LIKE, assea.ip(0x7fa72fa5e2a0), '%192.168.60.4%', '\\')(0x7fa72fa5d380)], [assea.ip_long(0x7fa72fa5c270) >= 0(0x7fa72fa5add0)], [assea.ip_long(0x7fa72fa5c270) <= 4294967295(0x7fa72fa5b470)]), rowset=256, 
      access([assea.id(0x7fa72fa5eb90)], [assea.ts(0x7fa72fa60e80)], [assea.ip_long(0x7fa72fa5c270)], [assea.ip(0x7fa72fa5e2a0)], [assea.first_time(0x7fa72fa5f180)]), partitions(p0), 
      limit(10), offset(nil), 
      is_index_back=true, filter_before_indexback[false,false,false], 
      range_key([assea.first_time(0x7fa72fa5f180)], [assea.id(0x7fa72fa5eb90)], [assea.ts(0x7fa72fa60e80)]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true

Used Hint:
-------------------------------------
  /*+
  */

Qb name trace:
-------------------------------------
  stmt_id:0, stmt_type:T_EXPLAIN 
  stmt_id:1, SEL$1
  stmt_id:2, SEL$2 > SEL$5C40C8D3


Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      INDEX(@"SEL$5C40C8D3" "hhit_asset"."assea"@"SEL$2" "sortKey01")
      MERGE(@"SEL$2" < "SEL$1")
      OPTIMIZER_FEATURES_ENABLE('4.0.0.0')
      END_OUTLINE_DATA
  */

Plan Type:
-------------------------------------
LOCAL

Optimization Info:
-------------------------------------
assea:table_rows:212654, physical_range_rows:213234, logical_range_rows:212690, index_back_rows:212690, output_rows:70896, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[sortKey01,key,hhit_asset], pruned_index_name[uid,sorkKey02,nkey], estimation info[table_id:504645, (table_type:10, version:-1--1--1, logical_rc:212657, physical_rc:212657), (table_type:12, version:-1--1--1, logical_rc:32, physical_rc:544), (table_type:0, version:-1--1--1, logical_rc:1, physical_rc:33)]


Parameters:
-------------------------------------