SQL: Advanced SQL Query optimization techniques
- Length: 125 pages
- Edition: 1
- Language: English
- Publication Date: 2021-07-11
- ISBN-10: B09978MXWX
- Sales Rank: #0 (See Top 100 Books)
Many companies worldwide suffer from one fundamental problem, and that is the inefficient functioning of their databases. While many know of database tuning and work to cover that aspect, professional database developers, managers, and administrators always miss one thing: optimizing their queries to save maximum time and cost and provide the query efficiently. Those who are aware of query optimization often lack the skillset and resources to implement this process at an advanced level efficiently. This book aims to make it easier for them.
Here are some ways this book will prove beneficial for readers of all types, e.g., database administrators, teachers, students, or people genuinely interested in databases:
- This book is free of any sort of jargon and complex discussions. The simple language aims to make it accessible to and implementable for people of all backgrounds.
- This book uses a very balanced approach. Too much time is not given to concepts that may be irrelevant, nor is anything missed out (purposefully) that may be of substantial importance to the readers.
- Simplified code is provided that can be used by the readers as a reference. This approach allows the readers to get onto practical implementation immediately.
- This book sticks to the point. That means the readers are likely to get exactly what they are looking for and will not find the book’s title misleading by the time they are done reading the book.
- This book attempts to cover all the aspects of query optimization. However, since it is not a textbook and just covers advanced optimization techniques, an adequate amount of background knowledge may be expected from the readers.
By the end of this book, readers will have a greater understanding of databases and understand all the considerations of efficient use of databases. The contents of this book will equip readers with the capability to practically apply the given concepts for efficient querying.
Take your database career to the next level!
Introduction Understanding Databases Today Structure of this Book Database Queries Chapter 1: Structured Query Language in Oracle The History of the SQL Variations in the SQL Today Procedural Language for SQL by Oracle The Syntax of PL/SQL Queries in the SQL & their Syntax Chapter 2: Query Processing & Query Optimization The Phases of Query Processing Fundamentals of Query Optimization Chapter 3: Query Optimization Techniques What is Optimization? What a Query Does The Tools What the Query Optimizer Does Common Query Optimization Themes Joins and WHERE Clauses Wrapped in Functions Implicit Conversions Chapter 4: Query Optimization Tips and Tricks Tips and Tricks Chapter 5: Using the Rule-Based Optimizer Understanding the RBO Access Paths Using RBO to Choose an Execution Plan for a Join Using the RBO to Transform and Optimize Statements Alternative SQL Syntax Chapter 6: Using the Cost-Based Optimizer and Database Statistics DBMS_STATS Chapter 7: Reading an Execution Plan What Is An Execution Plan? Chapter 8: SQL Server Query Optimization Techniques Understanding the Application Conclusion References
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.