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
------------------------------------------
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