MySQL Forums
Forum List  »  Optimizer & Parser

what does Collapse condition mean?
Posted by: jongse park
Date: April 10, 2011 07:25PM

I read The Range Access Method for Single-Part Indexes in mysql 5.5 manual.
In following;
3.Collapse conditions that are always true or false:
■(key1 LIKE 'abcde%' OR TRUE) is always true
■(key1 < 'uux' AND key1 > 'z') is always false

Are there some case of collapse condition for true or false?
I can't understand for collapse conditions.
What is collapse condition?

Options: ReplyQuote

Written By
what does Collapse condition mean?
April 10, 2011 07: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.