Perth SQL Server 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. He is an MCM, MVP, MCT, PDW Trainer, and proud Arsenal supporter. He spends a lot of his time either tuning queries or helping people with their BI systems, from small in-house data warehouses to large PDW implementations. His presentation style and his insight into the complex made simple and profound make him unique in the SQL Server community, with or without his guitar. He blogs at http://sqlblog.com/blogs/rob_farley and is on Twitter at @rob_farley.

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