Re: NAME_CONST slow down the query
Posted by:
Rick James
Date: August 19, 2015 01:39PM
WHERE CONVERT(MemberID USING utf8) COLLATE utf8_general_ci = CONVERT(InMemberID USING utf8) COLLATE utf8_general_ci;
is treating MemberID as a string. But it is not. Change to simply
WHERE MemberID = InMemberID;
Subject
Views
Written By
Posted
5099
August 14, 2015 03:33PM
2246
August 16, 2015 12:35PM
2060
August 17, 2015 03:25PM
2152
August 17, 2015 03:44PM
Re: NAME_CONST slow down the query
1787
August 19, 2015 01:39PM
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.