Was the WHERE clause allowed when the COLUMNSTORE index was first introduced with SQL Server 2012? I think not, but I haven't been able to find the official MS documentation from that time to back it up.
The best source I can find is this, which shows the syntax: Columnstore Index in SQL Server (sqlshack.com)
It seems a lot of other people thought the same, based on the answers to the question. 🙂
- This reply was modified 1 year, 5 months ago by kaj.