sys.json_indexes

Description

2025 (17.x) Preview Contains a row per json index. Indicates that array search optimization is enabled for JSON index. 1 = Array search optimization is enabled for JSON index. 0 = Array search optimization isn’t enabled for JSON indexes. The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.

Syntax

DROP
TABLE
IF
EXISTS dbo.Customers;
CREATE
TABLE dbo.Customers (
customer_id
INT
IDENTITY
PRIMARY
KEY
,
customer_info
JSON
NOT
NULL
);
CREATE
JSON
INDEX
CustomersJsonIndex
ON dbo.Customers (customer_info);
INSERT
INTO dbo.Customers (customer_info)