Databases Reference
In-Depth Information
F
Columns with the following data types should not be a part of a columnstore index:
decimal
or
numeric
with precision
>18
datetimeoffset
with precision
>2
binary
varbinary
image
text
ntext
varchar(max)
nvarchar(max)
cursor
hierarchyid
timestamp
uniqueidentifier
sqlvariant
xml
How to do it...
Follow the steps given here to perform this recipe:
1.
Execute the following query, which will seek the clustered index we had created
earlier in this chapter:
--executing query before creating columnstore Index
--and observ execution plan
SELECT
Refno
,sum(Amount) as SumAmt
,avg(Amount) as AvgAmt
FROM
ordDemo
WHERE
Refno>3
Group By
Refno
Order By
Refno
GO
Search WWH ::
Custom Search