Using index tag Client_id to rushmore optimize table a Rushmore optimization level for table a: partial Rushmore optimization level for table b: none Rushmore optimization level for table d: noneversion 2 - removed the IIF() around the loan number selection criteria and changed it to use BETWEEN.
AND (b.loan >= lcFromAccount); && changed lines AND (b.loan <= lcToAccount); Using index tag Client_id to rushmore optimize table a Rushmore optimization level for table a: partial Using index tag Loan to rushmore optimize table b && see the change here. Rushmore optimization level for table b: partial Rushmore optimization level for table d: noneThis appears to suggest I should somehow construct the query on the fly based on what criteria were filled in. If so, whats a good way to proceed?