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