SQL indexing best practices | How to make your database FASTER!
CockroachDB
View ChannelAbout
CockroachDB is the cloud native, distributed SQL database for the planet's most demanding enterprise applcations. Architected to help category leaders across industries and localities run mission-critical workloads that scale fast, survive disasters, and thrive everywhere. Our mission is to simplify how businesses build and run world-changing applications.
Latest Posts
Video Description
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
Pizza Oven Must-Haves
AI-recommended products based on this video
Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)
Windshield Crack Repair kit Windshield Repair kit, Glass Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit 2 Pack (Drakgray)
Paint Your Own Moon Lamp Kit, DIY 3D Moon Night Light with Space Figurines & Wooden Stand, Art Supplies Creativity Arts & Crafts Kit for Kids, Toys Girls Boy Birthday Easter Gift Ages 3 4 5 6 7 8 9 10 11 12+
LEGO Icons French Café Paris Building Kit - DIY Set for Adults - Collectible Bedroom and Home Decor - Display for Home or Office - Gift for Coffee Lovers - 10362
Vortopt Countertop Water Filter System - 5-Stage Stainless Steel Water Filter Faucet for 8000 Gallons - Tap Water Filter with KDF - Reduces Chlorine, Heavy Metals, Bad Odors - F7 - Includes 1 Filter
Brita Stainless Steel Premium Filtering Water Bottle, BPA-Free, Reusable, Insulated, Replaces 300 Plastic Water Bottles, Filter Lasts 2 Months or 40 Gallons, Includes 1 Filter, Carbon - 20 oz.
Waterdrop WD-CTF-01 Countertop Filtration System, 304 Food-Grade Stainless Steel, 6-Stage Faucet Water Filter, Long-Lasting Life, Reduces 99% of Chlorine, Heavy Metals, Bad Taste (1 Filter Included)
