JSON Filtered Indexes

preview_player
Показать описание
Generally, it's possible to get really fast query performance with JSON in SQL Server by building appropriate indexes on your data. But what if you want to add an index conditionally, only on certain rows? Filtered indexes can work, but there are a few things to be aware of.

Related blog post with example code:

Twitter:

Instagram:

Facebook:
Рекомендации по теме
Комментарии
Автор

Thanks. This is something I should be aware of when dealing with JSON-Data. Great content

HobbyWelt