Assistance Requested for SQL Execution Efficiency Issue

GooTen 

Hi, Chen.

These seem to be the estimated execution plans. Are you able to instead include the actual execution plans?

Here's the button from SSMS for including actual execution plans.

The actual execution plan shows how much real time (in milliseconds) was spent at each stage:

• Display an Actual Execution Plan - SQL Server | Microsoft Learn

If you can also add the following two lines to the end of each query after the "SORT BY" statement - only while you're capturing the actual execution plans (remove it again afterwards), that would be appreciated:

OPTION
	(RECOMPILE);

Also, I have to correct myself as I wasn't paying proper attention to what I had written about the indexes.

In my previous reply, I've incorrectly asked about an index on [makerid] when I'd meant to refer to the [ledger] column.

Similarly, is the [id] column in the [User] table indexed?

Your execution plans do involve a lot of table scanning, however, this may not be an issue. It just means it might be worth looking into, and the actual execution plan will help quantify that.

Cheers,

Lain