Could you please share the query profile so that I could help you find the problem.
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 > 网络无处不在，沟通及时到达 -- Best Regards, Yi Guo Lei SelectDB The Best Cloud Native Platform for Apache Doris Tel:134-3991-0228 Email:yiguo...@gmail.com --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@doris.apache.org For additional commands, e-mail: dev-h...@doris.apache.org
