Question : After our DBA got sacked for poor performance, I am now our accidental DBA. I have been pushing […]
Tag: columnstore
Getting Max for partition column in clustered columnstore index
Question : SQL 2014 Enterprise I have a datawarehouse table with ~ 800 million rows (total table size ~25 GB) […]
Does binary logging apply to ColumnStore?
Question : When binary logging is enabled, does MariaDB’s binary logging also record ColumnStore events, and not just InnoDB events? […]
How does a column-oriented DBMS filter on multiple columns?
Question : I’m learning how column-oriented DBMS / “columnars” work for OLAP situations. Let’s say we have a log of […]
If a rowstore index is stored in a b-tree data structure, what kind of data structure is used for a columnstore index? [duplicate]
Question : This question already has an answer here: What’s the anatomy of a columnstore index? (1 answer) Closed 2 […]
How many partitions should I make for my clustered columnstore index tables? Should I partition the rowstore tables also?
Question : I have a data warehouse comprised of four clustered columnstore index tables (CCI) and nine rowstore tables. These […]
Optimize BETWEEN Query in SQL Server Azure
Question : I have a table that stores time-series (5-minute) data and am trying to run a query that has […]
How to control Segmentation min/max data_id on a non-clustered ColumnStore index
Question : Given a simple row-based table without a PK but with a row-based clustered index like so: create clustered […]
Columnar DBMS and issue understanding multiple where constraints
Question : I read a lot about columnar DMBS and perfectly understand that they are great for researches on a […]
NC Columnstore and delete on batch
Question : hope you can give me some pointers on this behavior I have a NC Columnstore and in the […]