SET @userstat.save= @@userstat;

set global userstat= 1;

create table ft (c text,fulltext(c));

insert into ft (c) values ('Once upon a time'),

  ('There was a wicked witch'),('Who ate everybody up');

flush index_statistics;

select * from ft where MATCH(c) AGAINST('wicked');

show index_statistics;

explain select * from ft where MATCH(c) AGAINST('wicked');

# Cleanup

set global userstat= @userstat.save;

drop table ft;

flush index_statistics;

select * from ft where MATCH(c) AGAINST('wicked');

c

There was a wicked witch

show index_statistics;

Table_schema	Table_name	Index_name	Rows_read

explain select * from ft where MATCH(c) AGAINST('wicked');

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	SIMPLE	ft	fulltext	c	c	0		1	Using where