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
1122
November 29, 2017 01:39PM
591
November 29, 2017 04:21PM
609
November 29, 2017 04:38PM
588
November 29, 2017 05:16PM
647
November 29, 2017 05:25PM
586
November 29, 2017 06:13PM
648
November 29, 2017 06:23PM
651
November 29, 2017 07:46PM
622
November 30, 2017 10:31AM
577
December 01, 2017 11:02AM
570
December 01, 2017 11:05AM
607
December 01, 2017 11:19AM
637
December 01, 2017 11:26AM
589
December 01, 2017 01:04PM
610
December 01, 2017 01:10PM
566
December 01, 2017 05:01PM
Re: Compound index (pkey) not used when it should be
594
December 01, 2017 10:10AM
628
December 01, 2017 10:36AM