注册

limit性能问题

DM_317780 2024/06/25 441 4 已解决

【DM版本】:
DM Database Server 64 V8
DB Version: 0x7000c

【操作系统】:
【CPU】:
【问题描述】*:

select * from union_event
        where id in (
                    select event_id from union_event_person where
                    name = 'encrypt_zx1PE2Yg8by8z7yg33wt8N0V5fxuPy1b2Fl5rKnvnBE='
                    or id_number = 'encrypt_zx1PE2Yg8by8z7yg33wt8N0V5fxuPy1b2Fl5rKnvnBE='
                    or mobile = 'encrypt_zx1PE2Yg8by8z7yg33wt8N0V5fxuPy1b2Fl5rKnvnBE='
                )
        order by gmt_happen desc

使用limit搜索时,性能远低于不带limit的sql
3.png
1.png
2.png
是不是得配置索引提示和连接方法提示

回答 0
暂无回答
扫一扫
联系客服