Databases Reference
In-Depth Information
Getting ready
Before you start working with the columnstore index, find out its requirements, by checking
the following primary considerations:
F
Whether it is feasible to make your table read-only by creating a columnstore index
F
Is the table really very big with millions of rows?
F
If your database is OLTP, find out if are you able to disable columnstore index while
executing DML and enable it again after execution of DML to get the benefit of the
SELECT
statement
You may proceed to create a columnstore index if you have answered all the three questions
with
YES
.
Keep the following points in mind while weighing the decision to use the columnstore index:
F
You can't include more than 1024 columns
F
Columns with the following data types can be a part of a columnstore index:
int
big
int
small
int
tiny
int
money
smallmoney
bit
float
real
char(n)
varchar(n)
nchar(n)
nvarchar(n)
date
datetime
datetime2
small
datetime
time
datetimeoffset
, with precision
<=2
decimal
or
numeric
, with precision
<=18
Search WWH ::
Custom Search