mysql如何让视图利用索引？

刚发的帖子不够详细，来发个详细的。

1、我用存储过程动态生成视图。
2、每个table在time(时间戳)字段上均做了索引
3、各个table结构一样，view里面用union all，目的是把几张表拼成一张“大表”，这个view对外就是查询表。

下面是建立视图的存储过程，详细的我就不解释了，相信能够回答我这个问题的都能看懂。
SQL code:
CREATE DEFINER=`test`@`%` PROCEDURE `USP_ASS_CreateView`($ViewName VARCHAR(50),$TableName VARCHAR(100))
BEGIN
BEGIN
SET @DropView = CONCAT('DROP VIEW IF EXISTS ',$ViewName,';');
PREPARE DropView from @DropView;
EXECUTE DropView;
END;
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE tablename VARCHAR(50);
DECLARE Cmd VARCHAR(8000) DEFAULT '';
DECLARE Cur CURSOR FOR SELECT table_name from information_schema.TABLES WHERE table_name LIKE CONCAT('%',$TableName,'%');
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN Cur;
REPEAT
FETCH Cur INTO tablename;
IF NOT done THEN
SET Cmd = CONCAT(Cmd,'select * from ',tablename,' union all ');
END IF;
UNTIL done END REPEAT;
CLOSE Cur;
SET @Cmd = CONCAT('Create ALGORITHM = MERGE view ',$ViewName,' AS ',LEFT(cmd,LENGTH(cmd)-10),';');
PREPARE stmt from @Cmd;
EXECUTE stmt;
END;
END$$

DELIMITER ;



然后查询语句如下：

explain select * from table1 where time > 100000
------------------------------------------------