Bloom filter may help to dramatically reduce amount of data to be read from partitioned table by eliminating unneeded partitions. Here is a nice introduction into bloom… Read more “Yet another approach to overcome bloom filter bug”
Almost everyone who has some experience with Oracle knows about notorious notion called “context switches” between SQL and PL/SQL engines. You can find a great explanation of… Read more “Measuring context switches”
dbms_comparison was introduced in 11g as a powerful tool to compare and synchronize table data in different tables. Even though it’s quite flexible it has some limitations:… Read more “dbms_comparison”
I wonder why Oracle has not added possibility to change the list of statistics for autotrace but unfortunately that’s a fact. You cannot change the default format… Read more “Amending statistics list for autotrace”
There are many cases when executing some statement (either SQL or PL/SQL) may invoke execution of another SQL or PL/SQL statement. However it’s not at all obvious… Read more “Recursive calls and statistics”
As you may know there are two types of query transformations in Oracle: heuristic-based and cost-based. Heuristic-based transformations are supposed to produce better plan all the time… Read more “Query transformations in Oracle: or-expansion”
Query transformations in Oracle is a part of query optimization. In short, query optimization can be divided into three parts 1. Logical optimization: query transformation 2. Physical… Read more “Query transformations in Oracle: view merging”
This page contains all versions of my book The Power of Oracle SQL (rus).
Published title Oracle SQL Revealed (eng).
- Version 1.0 (download pdf)
Only first part of the book.
- Version 1.1 (download pdf)
Both parts. Subsections are listed in the contents as well as chapters.
A number of corrections has been made after feedbacks regarding the first part.
Some changes in compare to Russian version:
- First chapter was thoroughly refactored in order to make it easier to read. It has a huge number of examples and they have been structured a bit better.
- New chapter “Aggregate Functions” (it also includes information about pivoting/unpivoting).
- Some details about performance and internal implementation were added regarding pattern matching.
- Chapter “Logical Execution Order of Query Clauses” was completely reworked. In Russian version it contains a few inaccuracies which may lead to wrong conclusions.
- Solutions for a few of quizzes have been improved or changed. In particular, for Ordering Dependencies and Resemblance Group.
- Some new approaches have been introduced, for instance, for Zeckendorf Representation, etc.