In SQL Server, what is the difference between a user query and a system query? – Stack Overflow

So user seeks and scans appearing the usage management view seem appropriate, and the system scan from updating the statistics matches the answer given above.But back to the original question, I would say you don’t need to worry about system seeks and system scans on sys.dm_db_missing_index_group_stats. It seems like they would signify that SQL Server was attempting to look up some type of its own meta data and not having the correct internal indexes to satisfy the queries.

Источник: In SQL Server, what is the difference between a user query and a system query? – Stack Overflow

Традиционная проблема- оптимизатор не использует индекс, а почему непонятно. Вот буквально несколько часов назад решал такую же проблему, ломал голову. Пример решения. 

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *