Tag Archives: Cannot create index on view because it references common table expression. Views referencing common table expressions cannot be indexed. Consider not indexing the view

We create Indexed Views by adding indexes to views. For detailed information about the View concept, I would recommend you read my article “What is …