Hi All,
I was going thru my routine work of index tuning.In the course I created 2 indexes(refer below) on table LeadsMaster
PK__leadsmaster__1C1DF2EF : is clustered index on primary key
dpages:2242
reserved:2505
used:2497
rowcnt:46479
xmaxlen:8060
IX_iCustIDiProspID: is non clustered composite key on custid and prospid column
dpages:130
reserved:136
used:132
rowcnt:46479
xmaxlen:30
I was surprised to see the difference between the dpages column of both indexes.
Any one can explain me that y there is a difference between the dpages '
column of the 2 indexes
Thanx and Regards,
Ahmad
Bite off more than u chew,then chew it.
Regards,
[font="Verdana"]Sqlfrenzy[/font]