您好：
这个字段已经建立索引 但是还是很慢 INDEX idx_TRADE_DATE_STR (`TRADE_DATE_STR`) USING
INVERTED COMMENT ''；doris集群 1个fe 3个be 都为16核64G服务器
mysql> select * from mkt_cyq_chips2 where TRADE_DATE_STR >'20180116' order by
TRADE_DATE_STR limit 1;
+-----------+------------+-------+----------------+---------+------------+
| TS_CODE | TRADE_DATE | PRICE | TRADE_DATE_STR | PERCENT | PRICE_STEP |
+-----------+------------+-------+----------------+---------+------------+
| 000002.SZ | 2018-01-17 | 21.46 | 20180117 | 2.58 | NULL |
+-----------+------------+-------+----------------+---------+------------+
1 row in set (26.13 sec)
mysql> select * from mkt_cyq_chips2 where TRADE_DATE_STR >'20180116' limit 1;
+-----------+------------+-------+----------------+---------+------------+
| TS_CODE | TRADE_DATE | PRICE | TRADE_DATE_STR | PERCENT | PRICE_STEP |
+-----------+------------+-------+----------------+---------+------------+
| 000005.SZ | 2018-01-17 | 0.21 | 20180117 | 0.01 | NULL |
+-----------+------------+-------+----------------+---------+------------+
1 row in set (0.13 sec)
mysql>
mysql> select count(*) from mkt_cyq_chips2 where TRADE_DATE_STR >'20180116'
limit 1;
+-----------+
| count(*) |
+-----------+
| 502685518 |
+-----------+
1 row in set (9.31 sec)
mysql>
--
刘望发
上海网达软件有限公司
地址：上海市浦东新区新金桥路27号13号楼3层
手机：13801863843
电邮：[email protected]
网络无处不在，沟通及时到达
