set timing off

create table xyeta as
select
rpad(to_char(rownum), 20, '0') as account_number,
dbms_random.string('P', 100) as some_shit
from dual
connect by level <= 1e4;

Таблица создана.


create index  xyeta#account_number on xyeta(account_number);

Индекс создан.


set autotrace on

select *
from xyeta
where account_number like '1412419241241%';

строки не выбраны


План выполнения
----------------------------------------------------------
Plan hash value: 3721345436

----------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name                 | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                      |     1 |  2014 |     1   (0)| 00:00:01 |
|   1 |  TABLE ACCESS BY INDEX ROWID| XYETA                |     1 |  2014 |     1   (0)| 00:00:01 |
|*  2 |   INDEX RANGE SCAN          | XYETA#ACCOUNT_NUMBER |     1 |       |     1   (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("ACCOUNT_NUMBER" LIKE '1412419241241%')
       filter("ACCOUNT_NUMBER" LIKE '1412419241241%')

Note
-----
   - dynamic sampling used for this statement (level=2)
   - automatic DOP: Computed Degree of Parallelism is 1 because of parallel threshold


Статистика
----------------------------------------------------------
         11  recursive calls
          0  db block gets
         79  consistent gets
          1  physical reads
          0  redo size
        323  bytes sent via SQL*Net to client
        461  bytes received via SQL*Net from client
          1  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          0  rows processed


drop table xyeta purge;

Таблица удалена.