The Backend Engineering Show with Hussein Nasser

Can NULLs Improve your Database Queries Performance? - The Backend Engineering Show

Listen Later

In this episode, we will discuss NULLs in database systems. I’ll go through the following:

What is Null?

NULLs persistence

  • Whether you store a 0 or 2 billion value in the field 32bit integer field it costs 32 bit
  • when you store a NULL in 32 bit integer field we save 32 bit but add overheads

    • When NULLs are naughty

    • Semantics and inconsistent result
    • Select count(*). Includes nulls
    • count(column) ignores nulls
    • T is NULL returns the null rows
    • T is NOT NULL returns not null rows
    • T In (NULL) returns nothing
    • T not in NULL returns nothing
    • Some database don’t index nulls

      • When NULLs are useful

      • I don’t have value , I don’t wish to provide a birthday
      • not applicable field for certain use cases but not others fat tables (denormlization)
      • Fat tables with many columns makes your rows longer which means fewer rows fit in your page (show pic).. NULLs help here .. that are NULL, it yields shorter rows, instead of storing a default 0 value



        • Support my work on PayPal

        https://bit.ly/33ENps4

        Become a Member on YouTube

        https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join

        🧑‍🏫 Courses I Teach

        https://husseinnasser.com/courses

        ...more
        View all episodesView all episodes
        Download on the App Store
        The Backend Engineering Show with Hussein NasserBy Hussein Nasser
        • 4.9
        • 4.9
        • 4.9
        • 4.9
        • 4.9

        4.9

        40 ratings

        More shows like The Backend Engineering Show with Hussein Nasser

        View all
        Freakonomics Radio by Freakonomics Radio + Stitcher

        Freakonomics Radio

        32,245 Listeners

        Software Engineering Radio - the podcast for professional software developers by team@se-radio.net (SE-Radio Team)

        Software Engineering Radio - the podcast for professional software developers

        273 Listeners

        Risky Business by Patrick Gray

        Risky Business

        373 Listeners

        Science Vs by Spotify Studios

        Science Vs

        12,165 Listeners

        Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

        Syntax - Tasty Web Development Treats

        989 Listeners

        Darknet Diaries by Jack Rhysider

        Darknet Diaries

        8,110 Listeners

        Practical AI by Practical AI LLC

        Practical AI

        209 Listeners

        Within Reason by Alex J O'Connor

        Within Reason

        1,658 Listeners

        All-In with Chamath, Jason, Sacks & Friedberg by All-In Podcast, LLC

        All-In with Chamath, Jason, Sacks & Friedberg

        10,227 Listeners

        Dwarkesh Podcast by Dwarkesh Patel

        Dwarkesh Podcast

        548 Listeners

        Big Technology Podcast by Alex Kantrowitz

        Big Technology Podcast

        513 Listeners

        Hard Fork by The New York Times

        Hard Fork

        5,547 Listeners

        The AI Daily Brief: Artificial Intelligence News and Analysis by Nathaniel Whittemore

        The AI Daily Brief: Artificial Intelligence News and Analysis

        659 Listeners

        Prof G Markets by Vox Media Podcast Network

        Prof G Markets

        1,471 Listeners

        The Pragmatic Engineer by Gergely Orosz

        The Pragmatic Engineer

        74 Listeners