Re: Slow query
Posted by:
Rick James
Date: April 22, 2015 07:05PM
> id > '\0\0\0\0hI'
What is the datatype of `id`?
In addition to the EXPLAINs, please provide
SHOW CREATE TABLE dn;
SHOW VARIABLES LIKE 'char%' -- on both machines.
Subject
Views
Written By
Posted
2059
April 21, 2015 11:15AM
853
April 22, 2015 07:17AM
Re: Slow query
790
April 22, 2015 07:05PM
996
April 23, 2015 11:42PM
793
April 23, 2015 11:55PM
771
April 24, 2015 05:22PM
775
April 25, 2015 02:31AM
860
April 25, 2015 02:41AM
1486
April 25, 2015 05:22AM
827
April 25, 2015 10:42PM
880
April 28, 2015 03:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.