Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Discrepancy in Indexes

Status
Not open for further replies.

MAK9974

IS-IT--Management
Apr 11, 2002
145
US
I executed all these three statement first
------------------------------------------

DBCC DBREINDEX (order_detail, '', 80)
update statistics order_detail
DBCC UPDATEUSAGE ('PCC','order_detail')

when i execute sp_space used the results are
--------------------------------------------
reserved =805176 KB
data=380048 KB
index size = 424688 KB

Then I executed this
----------------------
select * from sysindexes where id = (select id from sysobjects where name = 'order_detail')

The results are strange
-------------------------
For indid = 1 the RESERVED =100647 KB


when i do 100647 + 380048 = 480695 why not 424688 KB??????

Say I calcluated for 80% index. Now i am calculating for 100% fillfactor

83872.5 + 380048 = 463920.5 KB why not 424688 KB??????


Please guide me.


-MAK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top