Search milions of rows from data set of 25 million

Off-Topic
1

i have created the trial account and have data around 25 million in table with full text index.

CREATE TABLE books(
id INT UNSIGNED,
title VARCHAR(100),
publish_year INT UNSIGNED,
body TEXT,
KEY (id) USING CLUSTERED COLUMNSTORE,
FULLTEXT ( body));

when i search using the query
|SELECT *|
||FROM books|
||WHERE MATCH (body) AGAINST (‘fox’);

It’s very slow searching that i need to check. due to its in-memory structure, it should return the result fast that is my expectation.
please guide how i can search fast

2

Could you share a profile of the query you are testing? Run profile select ... and then get the output of show profile.