Use the Index, Luke: SQL Indexing and Tuning E-Book
Markus Winand's website offers a free web-edition of "SQL Performance Explained," focusing on SQL indexing for developers. It covers indexing importance, optimization, pitfalls, techniques, and training services for SQL performance enhancement.
Read original article
The website "Use The Index, Luke" by Markus Winand offers a free web-edition of his book "SQL Performance Explained," focusing on SQL indexing for developers. The site covers SQL indexing in various databases like MySQL, Oracle, PostgreSQL, and SQL Server in a vendor-agnostic manner. It explains the importance of indexing during development and provides insights into optimizing search performance, index usage verification, and common pitfalls to avoid. The content includes details on indexing techniques, functions, case-insensitive search, over-indexing, and optimizing queries for ranges and LIKE filters. Additionally, it delves into topics such as join operations, clustering data, sorting, grouping, and modifying data with indexing considerations. The site also offers training and consulting services by Markus Winand for developers interested in enhancing their SQL performance skills. It provides a comprehensive resource for developers looking to improve their understanding of SQL indexing and tuning techniques across different database platforms.
Related
PostgreSQL Statistics, Indexes, and Pareto Data Distributions
Close's Dialer system faced challenges due to data growth affecting performance. Adjusting PostgreSQL statistics targets and separating datasets improved performance. Tips include managing dead rows and optimizing indexes for efficient operation.
Optimizing Large-Scale OpenStreetMap Data with SQLite
The article discusses optimizing large-scale OpenStreetMap data with SQLite. Converting OSMPBF to SQLite enhanced search functionalities. Indexing, full-text search, and compression improved query performance, despite some false positives.
Understanding Software Dynamics [book review]
The book "Understanding Software Dynamics" by Richard L. Sites, Addison-Wesley 2022, explores software performance analysis, emphasizing measurement techniques, KUTrace toolchain design, and practical performance analysis examples. Sites' approach benefits programmers, SREs, and system designers, offering insights for optimizing software services.
Show HN: I made a tool to visualize MySQL EXPLAIN query plans
Developers face challenges with slow MySQL queries, interpreting EXPLAIN output, common issues like ignoring slow queries, specific query elements' meanings, problems with filesort, and MySQL's index utilization limitations. MySQL's EXPLAIN aids query optimization.
After a deacade of using SQL it "clicked" for me
Kyle Benzle reflects on understanding SQL after years, comparing it to a tool for structured data management. He emphasizes SQL as a program for data manipulation, highlighting key commands for efficient database management.
1 commentsRelated
PostgreSQL Statistics, Indexes, and Pareto Data Distributions
Close's Dialer system faced challenges due to data growth affecting performance. Adjusting PostgreSQL statistics targets and separating datasets improved performance. Tips include managing dead rows and optimizing indexes for efficient operation.
Optimizing Large-Scale OpenStreetMap Data with SQLite
The article discusses optimizing large-scale OpenStreetMap data with SQLite. Converting OSMPBF to SQLite enhanced search functionalities. Indexing, full-text search, and compression improved query performance, despite some false positives.
Understanding Software Dynamics [book review]
The book "Understanding Software Dynamics" by Richard L. Sites, Addison-Wesley 2022, explores software performance analysis, emphasizing measurement techniques, KUTrace toolchain design, and practical performance analysis examples. Sites' approach benefits programmers, SREs, and system designers, offering insights for optimizing software services.
Show HN: I made a tool to visualize MySQL EXPLAIN query plans
Developers face challenges with slow MySQL queries, interpreting EXPLAIN output, common issues like ignoring slow queries, specific query elements' meanings, problems with filesort, and MySQL's index utilization limitations. MySQL's EXPLAIN aids query optimization.
After a deacade of using SQL it "clicked" for me
Kyle Benzle reflects on understanding SQL after years, comparing it to a tool for structured data management. He emphasizes SQL as a program for data manipulation, highlighting key commands for efficient database management.