A Deep Dive in How Slow SELECT * Is

A Deep Dive in How Slow SELECT * Is

Hussein Nasser via YouTube Direct link

Not All Columns are Inline

6 of 8

6 of 8

Not All Columns are Inline

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

A Deep Dive in How Slow SELECT * Is

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 Database Page Layout
  3. 3 How SELECT Works
  4. 4 No Index-Only Scans
  5. 5 Deserialization Cost
  6. 6 Not All Columns are Inline
  7. 7 Network Cost
  8. 8 Client Deserialization

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.