写了个视图,关联了10几张表,如下:
CREATE OR REPLACE VIEW XXX AS
SELECT COL1, COL2, COL3 ... FROM T1
UNION ALL
SELECT COL1, COL2, COL3 ... FROM T2
UNION ALL
SELECT COL1, COL2, COL3 ... FROM T3
.......
T1,T2,T3... 建有索引,查询条件中用到了索引字段,
但是查询效率很低,有好的解决办法吗?谢了!
CREATE OR REPLACE VIEW XXX AS
SELECT COL1, COL2, COL3 ... FROM T1
UNION ALL
SELECT COL1, COL2, COL3 ... FROM T2
UNION ALL
SELECT COL1, COL2, COL3 ... FROM T3
.......
T1,T2,T3... 建有索引,查询条件中用到了索引字段,
但是查询效率很低,有好的解决办法吗?谢了!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货