[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw ...
When you build query plans for SELECT statements, the query optimizer avoids nonclustered indexes and indexed views that reside in offline filegroups. This enables these statements to succeed. However ...
[3] See full list Intelligent Query Processing updates by release. [4] See additional SQL Server 2022 secure enclaves updates. [5] SQL Server Enterprise edition only. [6] The bidirectional disaster ...