Columnstore Indexes – Design Guidance SQL Server 2016

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-design-guidance

  • Use a clustered columnstore index for large data warehouse tables
  • Add btree nonclustered indexes for efficient table seeks
  • Use a nonclustered columnstore index for real-time analytics

 

  • columnstore
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s