Example of Use:
1> create table t1(c1 int)
2> go
1> alter table t1 partition 2
2> go
1>
2> insert into t1 values(1)
3> insert into t1 values(2)
4> insert into t1 values(3)
5> insert into t1 values(4)
6> insert into t1 values(5)
7> insert into t1 values(6)
8> insert into t1 values(7)
9> insert into t1 values(8)
10> insert into t1 values(9)
11> insert into t1 values(10)
12> go
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
1> update all statistics t1
2> go
1> update statistics t1(c1) using dynamic_histogram on
2> go
1>dbcc traceon(3604,12806)
2>go
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1> insert into t1 values(1000)
2> go
GROWINGCOLSTATS ups_update_growingcolstats: des=0x0x14eabe470
st_growingcol=0x0x1510081d0 colid=1 st_null_count=0 st_inrange_count=0
st_outofrange_count=1 st_dynamic_max=1000 st_sysstats_max=10
(1 row affected)
1>
Overview
Content Tools