Query optimizer doesn't consider the index in the execution plan for any Transact-SQL statements. For more information about filtered indexes, see Create filtered indexes and the SQL Server index ...
You can use the following options for the SELECT part of CTAS statement: Reading a warehouse table, such as a staging table. Reading a Lakehouse Delta Lake folder using an autogenerated table in SQL ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results