Spotligth Tuning - Query with OPENJSON

hI,

I need to improve a query (SELECT) with a OPENJSON (MS SQL Server 2016). But the Tuning cut the query until the instruction OPENJSON.

Example:

-- original

SELECT A, B, C
FROM TABLE  CROSS APPLY OPENJSON(JSON) WITH (
A NUMERIC '$.A', B NUMERIC '$.B', C NUMERIC '$.C') J;

-- cut

SELECT A, B, C
FROM TABLE  CROSS APPLY OPENJSON(JSON)

Regards,

Luis

Parents Reply Children
No Data