SQL indexing best practices | How to make your database FASTER!

Learn about best practices for using indexes in SQL, and how they can be used to speed up your queries, make your database faster, and improve your application's performance. Get started with CockroachDB: https://cockroachlabs.cloud/signup 0:00 Intro 0:05 Example database table 0:15 Example query 0:21 The problem with a full table scan 0:50 Using EXPLAIN ANALYZE 1:04 What is a SQL index? 1:17 How to create a single-column index 1:37 How to create a multi-column index 2:08 Optimizing our SQL query 2:31 Caveats of sql indexes Blog: https://www.cockroachlabs.com/blog/sql-performance-best-practices/ Docs: https://www.cockroachlabs.com/docs/stable/performance-best-practices-overview.html Free Course: https://university.cockroachlabs.com/courses/course-v1:crl+getting-started-with-sql-for-app-devs+self-paced/about Livestream | Making your queries FAST! https://www.youtube.com/live/Tcn5D4L9tJo