oracle亿级字符串查询,上亿级别数据查询语句优化，求大神啊

SQL> create table l(x varchar(10);

create table l(x varchar(10)

*

第 1 行出现错误:

ORA-00907: 缺失右括号

SQL> 1

1* create table l(x varchar(10)

SQL> a)

1* create table l(x varchar(10))

SQL> /

表已创建。

SQL> insert into l select 'aaa'||level from dual connect by level<=100;

已创建 100 行。

SQL> create index lx on l(x);

索引已创建。

SQL> select * from l where l like 'aaa99%';

select * from l where l like 'aaa99%'

*

第 1 行出现错误:

ORA-00904: "L": 标识符无效

SQL> set autot on

SP2-0618: 无法找到会话标识符。启用检查 PLUSTRACE 角色

SP2-0611: 启用 STATISTICS 报告时出错

SQL> select * from l where x like 'aaa99%';

X

----------

aaa99

执行计划

----------------------------------------------------------

Plan hash value: 3145445051

-------------------------------------------------------------------------

| Id  | Operation        | Name | Rows  | Bytes | Cost (%CPU)| Time     |

-------------------------------------------------------------------------

|   0 | SELECT STATEMENT |      |     1 |     7 |     1   (0)| 00:00:01 |

|*  1 |  INDEX RANGE SCAN| LX   |     1 |     7 |     1   (0)| 00:00:01 |

-------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

1 - access("X" LIKE 'aaa99%')

filter("X" LIKE 'aaa99%')

Note

-----

- dynamic sampling used for this statement (level=2)