select 'index Name' = i.[name],-- if you need to update all the indexes:
'Statistics Date' = stats_date(i.[object_id], i.index_id)
from sys.objects o
inner join sys.indexes i
on o.name = 'Employee'
and o.[object_id] = i.[object_id]
update statistics HumanResources.Employee
with fullscan
No comments:
Post a Comment