Skip to content

Instantly share code, notes, and snippets.

@3manuek
Created April 27, 2016 20:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 3manuek/2fd59b9a3a187784e02f82da520d775a to your computer and use it in GitHub Desktop.
Save 3manuek/2fd59b9a3a187784e02f82da520d775a to your computer and use it in GitHub Desktop.
Different query plans according with keywords
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