Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Database Indexing Explained (with PostgreSQL)

Hussein Nasser
469K subscribers
355K views 4 years ago
Get my Fundamentals of Database Engineering udemy course to learn more , link redirects to udemy with coupon applied https://database.husseinnasser.com This is a practical video on Database Indexing where I explain what is an index, why do we need it and how it can improve the performance of the queries. Also how (if used incorrectly) it can slow down your queries intro 0:00 What is an index 0:30 Describe Table 2:15 SELECT [ID] WHERE ID 4:00 SELECT [NAME] WHERE ID 6:30 SELECT [ID] WHERE [NAME] (No index) 9:20 SELECT [ID] WHERE NAME LIKE 11:12 CREATE INDEX ON [NAME] 12:00 SELECT [ID] WHERE NAME (Indexed) 12:50 SELECT [1D] WHERE NAME LIKE (Indexed) 14:30 Summary 16:00 Support my work on PayPal https://bit.ly/33ENps4 Become a Member on YouTube    / @hnasr   🧑‍🏫 Courses I Teach https://husseinnasser.com/courses 🏭 Backend Engineering Videos in Order https://backend.husseinnasser.com 💾 Database Engineering Videos    • Database Engineering   🏰 Load Balancing and Proxies Videos    • Proxies   🏛️ Software Archtiecture Videos    • Software Architecture   📩 Messaging Systems    • Message Queues & PubSub Systems   Become a Member    / @hnasr   Support me on PayPal https://bit.ly/33ENps4 Stay Awesome, Hussein ...more
...more
Database Indexing Explained (with PostgreSQL)
10KLikes
355,718Views
2020Sep 30
Get my Fundamentals of Database Engineering udemy course to learn more , link redirects to udemy with coupon applied https://database.husseinnasser.com This is a practical video on Database Indexing where I explain what is an index, why do we need it and how it can improve the performance of the queries. Also how (if used incorrectly) it can slow down your queries intro 0:00 What is an index 0:30 Describe Table 2:15 SELECT [ID] WHERE ID 4:00 SELECT [NAME] WHERE ID 6:30 SELECT [ID] WHERE [NAME] (No index) 9:20 SELECT [ID] WHERE NAME LIKE 11:12 CREATE INDEX ON [NAME] 12:00 SELECT [ID] WHERE NAME (Indexed) 12:50 SELECT [1D] WHERE NAME LIKE (Indexed) 14:30 Summary 16:00 Support my work on PayPal https://bit.ly/33ENps4 Become a Member on YouTube    / @hnasr   🧑‍🏫 Courses I Teach https://husseinnasser.com/courses 🏭 Backend Engineering Videos in Order https://backend.husseinnasser.com 💾 Database Engineering Videos    • Database Engineering   🏰 Load Balancing and Proxies Videos    • Proxies   🏛️ Software Archtiecture Videos    • Software Architecture   📩 Messaging Systems    • Message Queues & PubSub Systems   Become a Member    / @hnasr   Support me on PayPal https://bit.ly/33ENps4 Stay Awesome, Hussein
How this content was made
Auto-dubbed
Audio tracks for some languages were automatically generated. Learn more

Follow along using the transcript.

Hussein Nasser

469K subscribers