December 15, 2004 at 10:07 am
Hi,
we have found in some of the heap tables the no. of rows in the index pages(_WA_SYS_ System created statistics(non clustered indexes)) is greater than no of rows in the data pages. what is the root cause for this increase in the row count in index pages?
How to bring this to normal ie., rows in the data pages greater than or equal to rows in the index pages
I have already executed DBCC DBREINDEX,update statistics, dbcc updateusage commands on this tables but there is no improvement.
Awaiting for your replies with anticipation
December 15, 2004 at 2:31 pm
It shouldn't create more rows (at least not that I have ever seen or can recall running across before). How are you determining rows in the index also?
December 16, 2004 at 10:04 am
The output of the sysindexes table is as follows here we found the no. of rows in the data pages (indid =0) is less than the index pages(indid =2 and indid =3 (non clustered indexes)).(since we have droped all the statistics we are not able to give that value)
indid Index Name dpages reserved used rows
0 CALC_RESULT 767 1753 914 17220
2 PKCALCRESULT 82 88 84 18336
3 FKCALRESHEADER 60 40 37 18336
let us know the cause of above scenario
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply