I have a Blazor Server web application using MudBlazor and using Entity Framework (EF), and a SQL Server database as backend database.

I want to implement a search that searches across multiple tables for text values.

Eg. I have a series of tables with a [Name], [Description], and I want the search to search all the tables and search both the name and description values.

How do I design and implement a relative fast way of performing the search ?

Do I use EF to compile an advanced query? Do I use database views and indexing? Do I create an maintain a search-table with [Name] and [Description] and a reference to the origin-table?
Or do I use a combination of these approaches?

Please let me know if you have struggled with this, and what solutions you ended up with.

Querying multiple tables through EF queries or custom T-SQL SQL queries are simply too slow.