How non-persisted computed column indexes make your JSON queries high performance.
Did you know that non-persisted columns actually get saved to the index pages? This makes JSON querying incredibly fast in SQL Server.
Please like and subscribe if you enjoyed this video!
Blog post:
https://bertwagner.com/2017/05/09/one...
Want to receive the latest weekly blog posts and videos in your inbox? Sign up for the newsletter here: https://upscri.be/c77fc8/
Elsewhere on the internet:
https://bertwagner.com
/ bertwagner
On this page of the site you can watch the video online One SQL Cheat Code For Amazingly Fast JSON Queries - SQL JSON Index performance with a duration of hours minute second in good quality, which was uploaded by the user Bert Wagner 07 May 2017, share the link with friends and acquaintances, this video has already been watched 10,797 times on youtube and it was liked by 122 viewers. Enjoy your viewing!