drop table if exists flgp; create table flgp ( type int, name nvarchar(200), index ncci nonclustered columnstore (type), index ix_type(type) ); This table has two columns, one classic B-tree index, and one COLUMNSTORE index. B-tree index is better for the queries that need a limite...