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
1123
November 29, 2017 01:39PM
593
November 29, 2017 04:21PM
613
November 29, 2017 04:38PM
589
November 29, 2017 05:16PM
648
November 29, 2017 05:25PM
588
November 29, 2017 06:13PM
649
November 29, 2017 06:23PM
655
November 29, 2017 07:46PM
623
November 30, 2017 10:31AM
580
December 01, 2017 11:02AM
572
December 01, 2017 11:05AM
608
December 01, 2017 11:19AM
640
December 01, 2017 11:26AM
592
December 01, 2017 01:04PM
612
December 01, 2017 01:10PM
566
December 01, 2017 05:01PM
Re: Compound index (pkey) not used when it should be
596
December 01, 2017 10:10AM
632
December 01, 2017 10:36AM