被驱动表 拼接列无法走索引

create table t100(id int,name varchar(10));


create table t200(id int,name varchar(10));


begin 
  for i in  1..10
    loop
      insert into t100 values(i,i||'a');
    end loop;
    end;


begin 
  for i in  1..100000
    loop
      insert into t200 values(i,i);
    end loop;
    end;

        insert into t100 values(9999999,9999999||'a');


	SQL> explain plan for select name from t100 where name in (select name||'a' from t200);

已解释。

SQL> select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 4167129566

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