header
HomeAboutJobsMembershipArchives

 
NEXT MEETING:
Thursday, April 23rd 6:30 PM

 
LOCATION:
QuickStart
1500 NW Bethany Blvd
Suite 285
Beaverton, Oregon OR 97007
 
Directions to QuickStart:
Head West on Highway 26(Sunset Highway)
Exit at Cornell Road
Turn left at stoplight and cross over highway
Turn right onto Bethany Blvd at second stoplight.
The building is the first on your right.
Park in any open space
Click here for a map.
  PRESENTATION:

SQL Server Multi-Column Indexes vs Multiple Single Indexes

Understanding the multi-column index behaver is a foundation for all other indexes (multiple single indexes, covering indexes, filter indexes, bloom filter indexes).

A conceptual B-tree traversal and the query plans that correspond to the queries will be covered in the session. Multiple examples will be used to enhance our understanding how things work together. Through practice, when you read or write a query statement, you should be able to visualize what query plan you should get. With elements discussed from this session, next time you see an ugly query plan, you will know what question to ask and what to do to improve it

Bio:
Joshua Jin currently works on big data platform and develops architecture for security data products and services.
 

 


CORPORATE SPONSORS

QuickStart PASS Chapter Logo Prent Ozar Pluralsight - Harcore Developer Training
TEK Systems


copyright ©2015, Portland SQL Server User Group and pdxssug.com all rights reserved.
Redistribution of any portion of this site is forbidden without prior written permission.