vikaskalra
Technical User
Hi All,
I was wondering if any of you have faced such a problem. I have some big databases which have tables having more that 100,000 records per table.
The procedure here is we do lot of bulk inserts via DTS packages. Once this is done, the Sysindex table reflects the exact count or records for small tables. But for the big tables I have been observing that these counts are not getting updated.
I have already tried my luck with DBCC DBREINDEX to rebuild the index of these tabls, then I also tried my luck with UPDATE STATISTICS.. but none of these seem to be working and am merely left firing the time consuming SELECT COUNT(1) on these table to get the counts.
Any clue on as to how to get keep the Sysindex updated with correct count ?
I was wondering if any of you have faced such a problem. I have some big databases which have tables having more that 100,000 records per table.
The procedure here is we do lot of bulk inserts via DTS packages. Once this is done, the Sysindex table reflects the exact count or records for small tables. But for the big tables I have been observing that these counts are not getting updated.
I have already tried my luck with DBCC DBREINDEX to rebuild the index of these tabls, then I also tried my luck with UPDATE STATISTICS.. but none of these seem to be working and am merely left firing the time consuming SELECT COUNT(1) on these table to get the counts.
Any clue on as to how to get keep the Sysindex updated with correct count ?
