sql:explain extended SELECT id,first_time FROM (SELECT id,first_time FROM hhit_asset assea WHERE (assea.ip_long BETWEEN 0 AND 4294967295) AND assea.ip like '%192.168.60.4%' ORDER BY assea.first_time DESC  ) assea LIMIT 9 ;

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

Outputs & filters: 
-------------------------------------
  0 - output([assea.id(0x7f52f3e5eb60)], [assea.first_time(0x7f52f3e5f150)]), filter([(T_OP_LIKE, assea.ip(0x7f52f3e5e270), '%192.168.60.4%', '\\')(0x7f52f3e5d350)], [assea.ip_long(0x7f52f3e5c240) >= 0(0x7f52f3e5ada0)], [assea.ip_long(0x7f52f3e5c240) <= 4294967295(0x7f52f3e5b440)]), rowset=256, 
      access([assea.id(0x7f52f3e5eb60)], [assea.ts(0x7f52f3e60e50)], [assea.ip_long(0x7f52f3e5c240)], [assea.ip(0x7f52f3e5e270)], [assea.first_time(0x7f52f3e5f150)]), partitions(p0), 
      limit(9), offset(nil), 
      is_index_back=true, filter_before_indexback[false,false,false], 
      range_key([assea.first_time(0x7f52f3e5f150)], [assea.id(0x7f52f3e5eb60)], [assea.ts(0x7f52f3e60e50)]), 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:220500, logical_range_rows:212710, index_back_rows:212710, output_rows:70903, 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:212659, physical_rc:212659), (table_type:12, version:-1--1--1, logical_rc:15, physical_rc:15), (table_type:12, version:-1--1--1, logical_rc:37, physical_rc:7786), (table_type:0, version:-1--1--1, logical_rc:-1, physical_rc:40)]


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