OpenXML远程扫描性能

我正在寻找一些关于OpenXML的建议。具体来说,就是表演。我看到一小段XML的性能非常慢。

这导致了远程扫描。关于如何调整它有什么想法吗?

    DECLARE @idoc int
    EXEC sp_xml_preparedocument @idoc OUTPUT, @ResourceXML

    DECLARE @tmpRes TABLE (ResourceID int, Quantity int, FormID int)

    INSERT INTO @tmpRes (ResourceID, Quantity, FormID)
    SELECT  TMP.ID, TMP.Q, RESC.FormID 
    FROM    OPENXML(@idoc, '/Resources/R') WITH (ID int, Q int) TMP 
    INNER JOIN dbo.tblResources RESC ON TMP.ID = RESC.ResourceID
    WHERE   RESC.OrgID = @OrgID