However, if the offline filegroup contains the heap or clustered index of the target table, the SELECT statements fail. Additionally, any INSERT, UPDATE, or DELETE statement that modifies a table with ...

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricsqldb] Creates a relational index on a table or view. Also called a rowstore index because it is either a clustered or nonclustered B-tree ...