Wednesday 30 December 2009

DataChange Function to check update statistics in ASE 15

1> update statistics test1.tab1
2>
1> select datachange('test1.tab1',null,'name')
2>
---------------------------
128.571429
(1 row affected)
1> update all statistics test1.tab1
2>
1> select datachange('test1.tab1',null,'name')
2>
---------------------------
0.000000
(1 row affected)

1 comment: