MySQL Forums
Forum List  »  Optimizer & Parser

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

I read 7.13.1.1. 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


Subject
Views
Written By
Posted
what does Collapse condition mean?
3984
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.