为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:
【CPU】:
【问题描述】*:sql是这样的,
select * from A WHERE check_result != 'HIDE'
and list_id IN ( '01c93eacb9fe4d6784378b7fdcba99b3',
'05ceba0caad848afb6f9a27d7d34928c','188e7fa31e6c4d0db4481514f5efcdb7',
'1bcdbf0e71e64f38a8e049da0dc748a7','2479d5f7b9bd47d9a8c1a01dae72427f',
'33b0963627014e88b564760010594956','3f4d02200a844a318beebd96d87217c3',
'4c648ae83792433c8274b7a0ef1fe38c','7b6a007df0d840acb161fc6a42a4e95f',
'9388e25af451429798714da3efeedbf5','9578996a5f2848c284b3a1d82458e44c',
'97e1cbe0cf6d42de964e021dab3d1f0d','a6ba3899ec274981bebb67ba5a855f3c',
'b7f869f1be9542cbaea7dbba9011ea7e','bc259be10f2b4bfc96e42b0a80363956',
'c373d9cb05724203aa565c792af9a5de','c3ae58da383c492e98b4232a1898a5c0',
'c8ac50c8c54e4e61bdea1f9aba3363a0','cad0568c238947bbb2b83334b382ef8e',
'd1f425e4f58a47c49b5fbdb8299bc0f8','f155192e932048c28a17b13112d0d0e3',
'f3b9fa7f6ebe441ba13ea7da723beb46','773ea8411ece483aa4ba075f8a1de228',
'f56f3503fcd943dd8735d546f2dc8056','8850ebd82e6347bd8d4a7455da8de7f5',
'8a845097c3944251856959734a5a4a8b','b2bb788fcd1b45a6927a046150ceba7e',
'1cb019e3261a4f598690788256e260a7','0dd9c1c7f6d74dbd9d58009e7bc7fe7a',
'240836faf64a4a35b378e39501d0a1d9','c70ac50f73644e3a8e63ce2493a9dd75',
'a83b76a6ed7041feb3805edf22d4ced0','f883510f4c0249cb85f0e831b1816aab',
'7f63492fbcba44a18a7fd9844b5bf7d2','97e8a485506f466d97994e7d6b78e4a9',
'8344c90efbbc4080b2d723526c6df146','e4c016fecd6646d29912f9bb656ea1c7',
'05d23d40a3b44111be1caa2eb9251e1a','71ba4bb0615e4c87a9a861166be32168',
'9011539c880f41fbba77777da56f43c8',
'd53330b5f78644b49ea394df8c40a389','c18253b4eb7a4d359150c0ffba21d16b' )
order by create_time desc limit 0, 10;
我这个A表一共3个索引 一个 list_id索引,一个id索引 ,一个它俩的联合索引,为什么会使用id这个主键索引,求指教
1、list_id是不是大字段;2、你的条件列,in里面的值是否有序;3、更改sql,将in去掉

sql执行计划,以及索引的DDL麻烦贴一下