- Добавил: literator
- Дата: 1-04-2019, 01:36
- Комментариев: 0
Название: SQL Server Execution Plans, Third Edition
Автор: Grant Fritchey
Издательство: Red Gate Books
ISBN: 1910035246
Год: 2018
Страниц: 515
Язык: английский
Формат: True PDF
Размер: 23.64 MB
If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.
Автор: Grant Fritchey
Издательство: Red Gate Books
ISBN: 1910035246
Год: 2018
Страниц: 515
Язык: английский
Формат: True PDF
Размер: 23.64 MB
If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.