MySQL Forums
Forum List  »  Stored Procedures

Re: NAME_CONST slow down the query
Posted by: Rick James
Date: August 16, 2015 12:35PM

Your columns (MemberID) are hidden inside a function, so the index cannot be used. NAME_CONST is not relevant.

Please do SHOW CREATE TABLE so we can see more details.

Probably you just need to change the collation of the columns.

Also, so SHOW CREATE PROCEDURE; you may have established the 'wrong' COLLATION when creating it.

Options: ReplyQuote


Subject
Views
Written By
Posted
4374
August 14, 2015 03:33PM
Re: NAME_CONST slow down the query
1807
August 16, 2015 12:35PM
1689
August 17, 2015 03:25PM
1774
August 17, 2015 03:44PM
1522
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.