Re: order by 后速度特别慢

[Jiafeng.Zhang]

Let's get a profile


张家峰

liuwangfa <liuwan...@yeah.net>于2023年2月28日 周二11:42写道：

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

-- 
张家峰