https://blog.youkuaiyun.com/zhou85xinzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/zhou85xin/article/details/88336100https://blog.youkuaiyun.com/zhou85xin/article/details/88336100zhou85xinThu, 22 Sep 2016 20:25:24 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/52171190https://blog.youkuaiyun.com/zhou85xin/article/details/52171190zhou85xinThu, 11 Aug 2016 15:20:01 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/52182678https://blog.youkuaiyun.com/zhou85xin/article/details/52182678zhou85xinThu, 11 Aug 2016 15:00:15 +0800 idx_notice_type_tenant_id 是表kmd_notice的单列索引     结果很诧异，没有走索引，找DBA确认后，发现表的记录数只有9条，用索引要filter的记录数是5条，如果使用索引filter 的记录数占总记录数的17%以上(不确定)，则不走索引   2>  分别为2个字段建索引，用like前缀测试索引使用，结果如下:]]>https://blog.youkuaiyun.com/zhou85xin/article/details/52020520https://blog.youkuaiyun.com/zhou85xin/article/details/52020520zhou85xinMon, 25 Jul 2016 09:21:45 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/88336099https://blog.youkuaiyun.com/zhou85xin/article/details/88336099zhou85xinFri, 11 Mar 2016 10:41:19 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/48630581https://blog.youkuaiyun.com/zhou85xin/article/details/48630581zhou85xinMon, 21 Sep 2015 19:22:03 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/48542735https://blog.youkuaiyun.com/zhou85xin/article/details/48542735zhou85xinFri, 18 Sep 2015 14:25:39 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/88336098https://blog.youkuaiyun.com/zhou85xin/article/details/88336098zhou85xinMon, 11 May 2015 21:32:44 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/84717764https://blog.youkuaiyun.com/zhou85xin/article/details/84717764zhou85xinMon, 11 May 2015 21:32:44 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/45503853https://blog.youkuaiyun.com/zhou85xin/article/details/45503853zhou85xinTue, 05 May 2015 16:18:07 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/38663179https://blog.youkuaiyun.com/zhou85xin/article/details/38663179zhou85xinTue, 19 Aug 2014 09:56:33 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/38225603https://blog.youkuaiyun.com/zhou85xin/article/details/38225603zhou85xinMon, 28 Jul 2014 10:35:51 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/38224969https://blog.youkuaiyun.com/zhou85xin/article/details/38224969zhou85xinMon, 28 Jul 2014 10:03:20 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/38224403https://blog.youkuaiyun.com/zhou85xin/article/details/38224403zhou85xinMon, 28 Jul 2014 09:32:34 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/37692761https://blog.youkuaiyun.com/zhou85xin/article/details/37692761zhou85xinFri, 11 Jul 2014 11:24:32 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/32911801https://blog.youkuaiyun.com/zhou85xin/article/details/32911801zhou85xinSat, 21 Jun 2014 10:50:59 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/27229987https://blog.youkuaiyun.com/zhou85xin/article/details/27229987zhou85xinTue, 27 May 2014 19:58:08 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/27229721https://blog.youkuaiyun.com/zhou85xin/article/details/27229721zhou85xinTue, 27 May 2014 19:48:56 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/25293517https://blog.youkuaiyun.com/zhou85xin/article/details/25293517zhou85xinThu, 08 May 2014 11:46:11 +0800https://blog.youkuaiyun.com/zhou85xin/article/details/25240585https://blog.youkuaiyun.com/zhou85xin/article/details/25240585zhou85xinWed, 07 May 2014 19:29:23 +0800