mysql优化,视图union查询很慢。高手请入!
CREATE VIEW push_log AS
SELECT title, id, classid, titlepic FROM push_log_0 BETWEEN (UNIX_TIMESTAMP(NOW()) - ((3600 * 24) * 30)) AND UNIX_TIMESTAMP(NOW()))
UNION
SELECT title, id, classid, titlepic FROM push_log_1 BETWEEN (UNIX_TIMESTAMP(NOW()) - ((3600 * 24) * 30)) AND UNIX_TIMESTAMP(NOW()))
UNION
SELECT title, id, classid, titlepic FROM push_log_2 BETWEEN (UNIX_TIMESTAMP(NOW()) - ((3600 * 24) * 30)) AND UNIX_TIMESTAMP(NOW()))
UNION
SELECT title, id, classid, titlepic FROM push_log_3 BETWEEN (UNIX_TIMESTAMP(NOW()) - ((3600 * 24) * 30)) AND UNIX_TIMESTAMP(NOW()))
UNION ..........
像这样UNION连接后建立的mysql 视图 结果导致查询很慢 。, 请大家给个优化方案。 谢谢了。