Query execution optimization

Materials on analyzing and tuning query execution:

• Using query plans for query optimization — logical and execution plans, finding bottlenecks.
• Optimizer hints — influencing the cost-based optimizer via the PRAGMA ydb.OptimizerHints pragma.
• Parameterized queries and recompilation — why identical SQL structure recompiles when values are embedded in the query text.