create view v1 as select distinct id from t where name=‘xxx’;

–不走索引
select * from v1 where id=1;

–走索引
select distinct id from id where name=‘xxx’ and id=1;

问题：一些比较复杂的视图这样去查是不走索引，直接全表扫描，请教下这类问题应如何解决？