Estimated IO Cost
Vložit
- čas přidán 13. 03. 2024
- Looking for comprehensive, deep-dive training on SQL Server Performance Tuning? Explore SQLMaestros All-In-One Performance Tuning Bundle. 5 courses at a highly discounted price. bit.ly/sqlmaestrosallinone
The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world. - Věda a technologie
Thanks for the video. However, what’s the significance of this metric? Seemed like the only significance is that this metric is just a representation of the number of pages retrieved.
No, it's not actually a number like that. What we need to understand here is that the number of pages should be kept low. This can be achieved by setting the table structures and data types correctly. and therefore the input/output cost can be reduced.