Perth Microsoft Data and Analytics User Group

Event

Next Meeting: Thu, Oct 22 2015

The Power Of Composite Indexes

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/pssug-the-power-of-composite-indexes-rob-farley-tickets-18987219284

A composite index is when an index key uses multiple columns. Yet we see countless third-party applications recommending single-column index keys. In this session, we will explore the benefits of both scenarios, and also look at the impact on query plans, performance, blocking operators, and coverage. We will take a deep dive into concepts such as sargability, index intersection, inequality operations, and methods for writing queries that can help you get the most out of your indexing strategies, whether using composite or non-composite indexes.


When

iCal
UTC : Thu, Oct 22 2015 09:00 - 11:00
Event Time : Thu, Oct 22 2015 17:00 - 19:00 (UTC+08:00) Perth
Your Local Time: Thu, Oct 22 2015 09:00 - 11:00

Where

Level 3, 100 St George's Terrace
Perth , WA

Direction: None

Featured Presentation

The Power Of Composite Indexes

Speaker: Rob Farley, Owner/Principal LobsterPot Solutions

Summary: A composite index is when an index key uses multiple columns. Yet we see countless third-party applications recommending single-column index keys. In this session, we will explore the benefits of both scenarios, and also look at the impact on query plans, performance, blocking operators, and coverage. We will take a deep dive into concepts such as sargability, index intersection, inequality operations, and methods for writing queries that can help you get the most out of your indexing strategies, whether using composite or non-composite indexes.

About Rob: Rob Farley runs LobsterPot Solutions, a specialist data consultancy dealing with the Microsoft Data Platform. He's been an MVP since 2006, largely because of his blogging, his presentations around the world, and his dedication to the Adelaide SQL Server User Group which he has led since before the release of SQL Server 2005. He's on Twitter at @rob_farley, but you can always email him using rob@lobsterpot.com.au

Attachments

PASSChapterLogo100.jpg 

PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall DBA provides us with complimentary refreshments each month.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids