如需獲得最佳網頁瀏覽體驗,請使用 IE 11 或更高版本、Chrome、Firefox 或 Safari。

Making the Most of Indexes in Microsoft SQL Server

Making the Most of Indexes in Microsoft SQL Server
录播
  • 记录日期:Mar. 26, 2019
  • 活动:录播
Making the Most of Indexes in Microsoft SQL Server

SQL queries aren’t performing well? Already know you’ve got enough hardware to handle the load? Then you’re probably wondering what to check next. One area is the indexing on the data and how those indexes are used. Not having indexes, or having incorrect indexes, forces SQL Server to work harder to return the same data. Or maybe you have the proper indexes, but the queries themselves aren’t making effective use of them. No worries! SQL Server expert Brian Kelley has you covered with everything you need to know about SQL Server indexes.

In this session, you’ll gain a deeper understanding of the SQL Server parse process. You’ll learn how SQL Server parses a query and determines its execution plan for retrieving or updating data. We’ll also review the types of indexes and how SQL Server uses them to increase the efficiency of data access and how poorly written queries can result in not using indexes that would otherwise benefit us. Finally, we’ll talk about how to improve our indexing and queries together for increased SQL Server performance.

扬声器

Brian Kelley - SQL Server Expert

观看免费网络直播

请稍候……

triangle-down check
进行下载即表示您注册以接收我们发送的营销电子邮件。要选择不再接收,请按照我们隐私政策中描述的步骤进行操作。

reCAPTCHA为此站点提供保护。请查看Google的隐私政策使用条款