Imagine i have 20 million records in a table called User and i want to have a full text search on a column called Description.

i read about a FreeText in EF Core which it is look like this:

   var results = _context.Users
                         .Where(e => EF.Functions.FreeText("*", "search criteria"));

but i want to have a Full Search with good performance

is there any suggestion?