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
1282
November 29, 2017 01:39PM
653
November 29, 2017 04:21PM
696
November 29, 2017 04:38PM
657
November 29, 2017 05:16PM
749
November 29, 2017 05:25PM
670
November 29, 2017 06:13PM
737
November 29, 2017 06:23PM
764
November 29, 2017 07:46PM
774
November 30, 2017 10:31AM
667
December 01, 2017 11:02AM
658
December 01, 2017 11:05AM
708
December 01, 2017 11:19AM
771
December 01, 2017 11:26AM
666
December 01, 2017 01:04PM
714
December 01, 2017 01:10PM
699
December 01, 2017 05:01PM
Re: Compound index (pkey) not used when it should be
749
December 01, 2017 10:10AM
745
December 01, 2017 10:36AM