after rebuild

hi ,

i am having some doubts regarding rebuild and reorgainze indexes.
after run the rebuild and reorganize,
i run this smt . for avg_page_space_used_in_percent value is null for all indexes and for some tables when i run alter rebuild statements the output is not varying same as previous ones.


SELECT distinct a.index_id, name, avg_fragmentation_in_percent,avg_fragment_size_in_pages,avg_page_space_used_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(), OBJECT_ID(N'etrans'),
NULL, NULL, NULL) AS a
JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id;


is it compulsory to run update statitics after running rebuild and reorganize?


after done rebuild and reorganize also users are facing still the performance is slow for that application.

pls help someone .


thanks ,
kumar p

hi , thanks for reply
i rebuilled all indexes and i didn't perform any shirnking
while selecting ,updating the any things in the application the performance is slow
i don't known excatly slow response or slow running queries
whn i checked in sql profiler while updataing or selecting long queries it will take some time
thanks
kumar

thanks satya ,
i'll check ,
we have so maany application running present , but only this application running slow
thanks
kumar

If you have rebuild the indexes using the DBCC DBREINDEX then update statistics is done automatically.
Couple of troublehooting paths to application slow down
1> Did you recently increase number of users ?
2> Please check if there are blocks when the users are complaining application slow down , you can use "select * from sysprocesses where blocked >0 and spid >51"
3> Please check out similar posts in forums for application slow down since there are many here that can help you which are elborated well.
Cheers
Sat

hi , thanks for reply babu
i didn't increase any users. when i run the select stmt no blocking process are there .
i rebuild the indexes using alter index .............. cmd
thanks
kumar