Update statistics for table with more then 2^31 records
Hi, everybody,
We've run into a funny problem with our DataWarehouse database:
update statistics HIGH and MEDIUM doesn't work for tables with more
then 2^31 = 2147483648 records (no need to say, that table is
fragmented)
Operation finishes immediately without any error, and doesn't create any
SYSDISTRIB record.
Also, SYSTABLES always gives 2^31-1 records for big tables: NROWS is of
type INT4...
One can conclude, that 'update statistics' was never supposed to work
for bigger tables.
I've filed a PMR to IBM 'passport advantage' support
-------------------------
Alexey Sonkin
↪ replying to Alexey Sonkin