First introduced in SQL Server ... a B-tree) that has a key value, which allows the database engine to quickly retrieve the row needed using a key. Columnstore indexes instead store each column ...

They cannot be created as filtered index, placed on computed or sparse columns, multiple columns at once ... columnstore indexes are much smaller than B-tree indexes, often as much as a factor of 4x ...