DEFINITIONS

Definitions More Info.
Definition ID16.117
TitleSQL
CategoryNOTES
DefinitionSQL kullanilmayan index- not usable indexes
Definition Description-- Kaynak chatgpt
SELECT
OBJECT_NAME(s.object_id) AS TableName,
i.name AS IndexName,
s.user_seeks,
s.user_scans,
s.user_lookups,
s.user_updates
FROM
sys.dm_db_index_usage_stats AS s
INNER JOIN sys.indexes AS i
ON s.object_id = i.object_id AND s.index_id = i.index_id
WHERE
s.database_id = DB_ID('AtlantisDB')
AND OBJECT_NAME(s.object_id) = 'AdayLogDB';
RecordBycunay
Record Date25-07-2024 14:16:47
Düzenle
Kopyala
Sil