Database Reference
In-Depth Information
You can see that the column
C1
is using the
int
data type and the column
C2
is using
varchar(50)
.
If I run a simple
select
from the table
t2
, we will see that the table is empty, as
shown in the following screenshot:
So, with the clustered columnstore index created, you would want to populate
the table with some data. The following
INSERT
statement will insert two rows
in the table:
USE [DB1]
GO
INSERT INTO [dbo].[t2]
([c1],[c2])
VALUES
(1,'Gethyn'),
(2,'Seth')
GO
Search WWH ::
Custom Search