select when use field in (eg. select * from xxx where fi in ('aaa') ) . it's slow

[pope12389]

Performance Issue
Any questions related to TDengine's performance can be discussed here.

Problem Description
A clear and concise description of what the problem is.

To Reproduce
Steps to reproduce the behavior:

1. Database parameters used:
   Welcome to the TDengine Command Line Interface, Client Version:3.3.1.0
   Copyright (c) 2023 by TDengine, all rights reserved.

2. Verbs used: Select

3. Describe the total amount of data:
   taos> select count() from dev_running_data ;
   count() |
   ========================
   137895228 |
   Query OK, 1 row(s) in set (3.383623s)

do this select:
select * from dev_running_data where dev_id in ('0a9023386e234529936ae6eb59a5e641') limit 2;
Query OK, 2 row(s) in set (41.276906s)

when use this select :
select * from dev_running_data order by create_time desc limit 2;
Query OK, 2 row(s) in set (1.991381s)

other server config use the default.

Environment (please complete the following information):

• OS: CentOS Linux release 7.9.2009 (Core)

• Memory:128G, CPU: Intel(R) Xeon(R) Gold 6278C CPU @ 2.60GHz , current Disk Space:120G

• TDengine Version [3.3.1.0]

Additional Context

[yu285]

dev_id is a tag ?