MySQL Forums
Forum List  »  Newbie

Re: Function based index on a existing table column
Posted by: Rick James
Date: September 01, 2016 10:25PM

Please show us the actual query, not handwaving like "col1 <= col1 +offset".

If it involves datetime, you can almost always rearrange the expression to put the indexed column on one side and an expression on the other.

Options: ReplyQuote


Subject
Written By
Posted
Re: Function based index on a existing table column
September 01, 2016 10:25PM


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.