index fragmentation

select object_name(object_id) ,index_id,index_type_desc,

avg_fragmentation_in_percent

from sys.dm_db_index_physical_stats(db_id('test'),null,null, null,'LIMITED')

--index usage

select i.name,user_seeks,user_scans,last_user_seek,last_user_scan

from sys.dm_db_index_usage_stats s inner join

sys.indexes i on

s.object_id = i.object_id

and s.index_id = i.index_id

where database_id =  db_id('test')

thanx again sql server recipe book