Skip to content
Can NULLs Improve your Database Queries Performance? - The Backend Engineering Show episode artwork

Apr 11, 2021 22 min

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

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

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

0:00 22:41

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 22 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on April 11, 2021.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.