breaking a myth in 600 seconds: seek is always better than scan

1
Breaking a Myth in 600 Seconds SEEK IS ALWAYS BETTER THAN SCAN G.R. Prithiviraj Kulasingham Associate Database Architect, Pearson Lanka MVP, MCITP:DBA

Upload: sql-server-sri-lanka-user-group

Post on 24-Jun-2015

24 views

Category:

Data & Analytics


0 download

DESCRIPTION

201206 - Session 2 TITLE: Breaking a Myth in 600 Seconds: Seek is Always Better than Scan SPEAKER: Prithiviraj Kulasingham (@preethi_1965)

TRANSCRIPT

Page 1: Breaking a Myth in 600 Seconds: Seek is Always Better than Scan

Breaking a Myth in 600 SecondsSEEK IS ALWAYS BETTER THAN SCAN

G.R. Prithiviraj KulasinghamAssociate Database Architect, Pearson Lanka

MVP, MCITP:DBA