Created
April 27, 2016 20:43
-
-
Save 3manuek/2fd59b9a3a187784e02f82da520d775a to your computer and use it in GitHub Desktop.
Different query plans according with keywords
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
explain select * | |
from bookContentByLine | |
where match(content) against ("+home" IN BOOLEAN MODE) | |
ORDER BY FTS_DOC_ID | |
LIMIT 10\G | |
select_type: SIMPLE | |
table: bookContentByLine | |
type: fulltext | |
Extra: Using where; Ft_hints: no_ranking; Using filesort | |
explain select * | |
from bookContentByLine | |
where match(content) against ("+home" IN BOOLEAN MODE) | |
LIMIT 10\G | |
table: bookContentByLine | |
type: fulltext | |
Extra: Using where; Ft_hints: no_ranking, limit = 10 | |
explain select count(content) | |
from bookContentByLine | |
where match(content) against ("+home" IN BOOLEAN MODE) \G | |
table: bookContentByLine | |
type: fulltext | |
Extra: Using where; Ft_hints: no_ranking |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment