级联性能低

Question

我正在使用以下代码来选择我想要的行，但问题是它在从其他表中选择DocumentNumber列时性能较低，问题出在这个部分-> ('IN-'+@ItemStatus+'#'+chequeserial)

SELECT     
    Banking.ReceivedCheque.Date, Banking.ReceivedCheque.StatusDate,
    Banking.ReceivedCheque.DueDate, Banking.ReceivedCheque.ChequeSerial, 
    Banking.ReceivedCheque.BankName Banking.ReceivedCheque.CompanyInfoFK, 
    Banking.ReceivedCheque.FinancialPeriodFK, 
    Banking.ReceivedCheque.CreditGFK, Banking.ReceivedCheque.CreditID, 
    ReceivedFromAccount = dbo.getname(CreditID, CreditGFK, FinancialPeriodFK),
    DefBankAccount = dbo.getname(DefaultBankID, '4', FinancialPeriodFK), 
    Banking.ReceivedCheque.StatusFK,
    Banking.ChequeStatus.Title,
    (SELECT MAX(DocumentFK) 
     FROM Accounting.DocumentDetail 
     WHERE ItemFK = ('IN-' + @ItemStatus + '#' + chequeserial)  
       AND financialPeriodFK = @FinancialPeriodFK) AS DocumentNumber
FROM         
    Banking.ReceivedCheque 
INNER JOIN
    Banking.ChequeStatus ON Banking.ReceivedCheque.StatusFK = Banking.ChequeStatus.ChequeStatusID
WHERE
    ReceivedCheque.FinancialPeriodFK = @FinancialPeriodFK  
    AND Banking.ReceivedCheque.StatusFK = @StatusFK

请让我知道是否有任何其他解决方案来提高性能。