How is the performance of when we store data in JSON?
Will it impact on creating the report from this JSON Column?
This is a common concern.
It has been benchmarked and explained in detail here
Please go through and let us know if you have further questions.
Also, you havent mentioned about your reporting solution here.
If It is PowerBI, you could read once, cache the dataset and improve performance in a big way.
If this answers your query, please “Accept the answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .
5 people are following this question.