USE yuksel2 SELECT o.name 'Table Name', i.name 'Index Name', i.type 'Index Type' ,STATS_DATE(i.[object_id], i.[index_id]) 'Last Statistics Update' FROM sys.indexes i, sys.objects o WHERE i.[object_id]=o.[object_id] AND o.type='U' AND i.name IS NOT NULL AND STATS_DATE(i.object_id, i.index_id) < DATEADD(DAY, -1, GETDATE()) ORDER BY 'Last Statistics Update' DESC
