JSON запросы - насколько эффективны

ALTER PROCEDURE GetInfoByLotWithApplicationsForUser (@lotId int, @companyId int)
AS
BEGIN
 
declare @applicationJSON nvarchar(max)
set @applicationJSON = (Select app.Id, 
    StatusId,
    app.CreationDate, 
    SendDate,
    case app.SignedData
    WHEN NULL
    THEN cast(0 as bit)
    ELSE cast(1 as bit)
    END as 'IsSigned',
    Documents.Id,
    Documents.Name,
    Documents.Comment,
    Documents.DocumentTypeId as 'DocumentType',
    Documents.Path,
    Documents.MimeType,
    CASE Documents.SignedData
            WHEN NULL 
            THEN cast(0 as bit)
            ELSE cast(1 as bit)
            END as 'IsSignatureVendor'
    from TradeApplication app
    inner join DocumentTradeApplication dt on dt.ApplicationsId = Id
    inner join Document Documents on Documents.Id = dt.AttachmentsId
    where app.TradeLotId = @lotId and app.CompanyId = @companyId 
    for json AUTO, WITHOUT_ARRAY_WRAPPER)
 
    select cast((Select lot.Id,
    lot.Name, 
    comp.Name as 'CompanyName',
    comp.Id as 'CompanyId',
    acc.Id as 'AccountId',
    lot.TradeTypeId as 'TradeTypeId',
    (Select StatusId from TradeApplication where TradeLotId = lot.Id and CompanyId = @companyId) 'TradeApplicationStatus',
    lot.Information,
    lot.BasePrice,
    lot.CurrentPrice,
    lot.BuyNowPrice,
    lot.StepValue,
    lot.StepPercent,
    lot.DepositSize,
    lot.TradePeriodLength,
    lot.LotTradePeriodStart,
    lot.LotTradePeriodEnd,
    lot.LotApplicationPeriodStart,
    lot.LotApplicationPeriodEnd,
    JSON_QUERY(@applicationJSON) as [Application],
    CASE when exists(SELECT id, Price
                      FROM LotPrice
                      WHERE Price = (SELECT MAX(Price) FROM LotPrice where LotId = lot.Id) and CompanyId = @companyId and lot.LotTradeStateId = 37)
      THEN cast(1 as bit)
      ELSE cast(0 as bit)
      END as 'IsWinner',
    CASE when exists(SELECT id
                      FROM Favorites
                      WHERE LotId = lot.Id and UserId = acc.Id)
        THEN cast(1 as bit)
        ELSE cast(0 as bit) 
      END as 'IsHasFavorites',
    CASE when exists(SELECT id
                      FROM AccountSubscriptions
                      WHERE UserId = acc.Id and SubscribedCompanyId = @companyId)
        THEN cast(1 as bit)
        ELSE cast(0 as bit) 
      END as 'IsSubscribed',
    (Select doc.Id,
            doc.AccountId as 'OwnerAccountId',
            doc.Name, 
            doc.Comment,
            doc.Path,
            doc.DocumentTypeId as 'DocumentType',
            CASE SignedData
            WHEN NULL 
            THEN cast(0 as bit)
            ELSE cast(1 as bit)
            END as 'IsSignatureVendor',
            CASE WinnerSignedData
            WHEN NULL 
            THEN cast(0 as bit)
            ELSE cast(1 as bit)
            END as 'IsSignatureWinner',
            doc.SignDate as 'DateSignVendor', 
            doc.SignedData,  
            CreationDate,
            MimeType 
        
      from DocumentTradeLot 
      inner join Document doc on doc.Id = AttachmentsId
      where LotsId = lot.Id 
    for json path) [Documents],
 
    (Select Id, FileName, DisplayNumber, Url, ContentType 
    from MediaFile 
    where TradeLotId = lot.Id order by DisplayNumber 
    for json path) [Pictures],
 
    (Select f.Name as 'FilterName', lf.Value, fg.Name as 'GroupName'
    from Filters f
    inner join LotFilterValues lf on lf.FilterId = f.Id and lf.LotId = lot.Id
    inner join FilterGroups fg on fg.Id = f.FilterGroupId
    for json path) [Filters]
 
    from TradeLot lot 
    inner join Company comp on comp.Id = lot.OrganizerId
    inner join Account acc on acc.CompanyId = comp.Id
    where lot.Id = @lotId
    for json path, WITHOUT_ARRAY_WRAPPER) AS VARCHAR(MAX)) AS JSONDATA
END