Sample Header Ad - 728x90

Performance implications of OPENJSON in view

2 votes
3 answers
974 views
Earlier today, I needed to put some small data quickly in a SQL Server database: CREATE VIEW MyView AS SELECT * FROM OPENJSON('[ ... ]') WITH ( colA int, etc. ); intending to go back and replace this with a real CREATE TABLE, INSERT INTO, etc. at some point. SQL Server isn't doing anything smart to cache or store this data, is it? It is parsing the JSON every time the view is queried, right? Just wanted to make sure before I replace it.
Asked by Jacob Brown (21 rep)
Oct 26, 2023, 08:08 PM
Last activity: Oct 27, 2023, 07:46 PM