order by 后速度特别慢

[liuwangfa]

您好：
     这个字段已经建立索引 但是还是很慢  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
电邮：liuwan...@wondertek.com.cn
网络无处不在，沟通及时到达