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:
<code> var results = _context.Users
.Where(e => EF.Functions.FreeText("*", "search criteria"));
</code>
<code> var results = _context.Users
.Where(e => EF.Functions.FreeText("*", "search criteria"));
</code>
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?