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
1406
November 29, 2017 01:39PM
707
November 29, 2017 04:21PM
748
November 29, 2017 04:38PM
704
November 29, 2017 05:16PM
801
November 29, 2017 05:25PM
717
November 29, 2017 06:13PM
784
November 29, 2017 06:23PM
846
November 29, 2017 07:46PM
831
November 30, 2017 10:31AM
718
December 01, 2017 11:02AM
712
December 01, 2017 11:05AM
780
December 01, 2017 11:19AM
824
December 01, 2017 11:26AM
716
December 01, 2017 01:04PM
762
December 01, 2017 01:10PM
753
December 01, 2017 05:01PM
Re: Compound index (pkey) not used when it should be
802
December 01, 2017 10:10AM
792
December 01, 2017 10:36AM