睡月花儿

  • Home
  • About
  • coding
  • Tags86
  • Categories7
  • Posts870
  • Sitemap
  • Commonweal 404
  • Search
  • Table of Contents
  • Overview
戛戛Happy

戛戛Happy

后端, 操作系统, 互联网, 程序开发, Linux, 数据库, MySql, Golang, Ruby
RSS
Creative Commons

mysql 强制指定索引

Posted on 2015-02-26 In mysql , innodb

mysql 强制指定索引

select * from t_a_index force index(a_b) where a = 1 and b = 1  order by a desc;
select * from t_a_index ignore index(a_b) where a = 1 and b = 1  order by a desc;
  • Post author: 戛戛Happy
  • Post link: https://blog.gagahappy.cn/mysql-force-index/
  • Copyright Notice: All articles in this blog are licensed under BY-NC-SA unless stating additionally.
数据库
Multi-Range-Read优化的好处
索引提示
京ICP备10044755号
© 2009 – 2024 戛戛Happy
Powered by Hexo & NexT.Gemini