Re: Compound index (pkey) not used when it should be
Hi,
Unfortunately, MySQL does not recognize that an index range scan can be used for "(x,y) >= (a,b)". Try rewriting the query to use "(x > a) OR (x = a AND y >= b)".
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
1389
November 29, 2017 01:39PM
698
November 29, 2017 04:21PM
736
November 29, 2017 04:38PM
692
November 29, 2017 05:16PM
789
November 29, 2017 05:25PM
707
November 29, 2017 06:13PM
776
November 29, 2017 06:23PM
831
November 29, 2017 07:46PM
817
November 30, 2017 10:31AM
705
December 01, 2017 11:02AM
701
December 01, 2017 11:05AM
756
December 01, 2017 11:19AM
815
December 01, 2017 11:26AM
703
December 01, 2017 01:04PM
752
December 01, 2017 01:10PM
741
December 01, 2017 05:01PM
Re: Compound index (pkey) not used when it should be
791
December 01, 2017 10:10AM
781
December 01, 2017 10:36AM