Hi Brian

I agree that a single de-normalized table is best with FTI. I created an indexed view which contains the fields from both tables and created the FTI on the...

Hi Brian

I had a look at using the union approach but it's not going to work. The query is actually more complex. It's dynamically generated based on how many search...

Hi Brian

I have added a non-clustered index to the foreign key:

CREATE NONCLUSTERED INDEX IX_WCContact_ContactId ON CS.WCContact ( FileId ASC)

I have updated statistics:

UPDATE STATISTICS [CS].[WCContact] WITH FULLSCAN

I ran the full query...

The file upload got rejected. Here is a link to download the file:

https://1drv.ms/u/s!AgdNTno_yQL5g8kC7isX-EBVjaZAMw?e=pmJIl2

Thanks for your advice. I will review and get back to you today.

Hi Brian

I've saved the Execution Plan of the slow query and attached it here.

Here is the warning message:

Type conversion in expression (CONVERT(varchar(10),[c].[DateOfAquisition],103)) may affect "CardinalityEstimate" in query plan choice,...

Hi Brian

Thanks for getting back to me. I'll provide two version. The first version is without the OR which runs instantly. The second version is with the OR which takes...