Anti Join with Range Predicate
Performance issue in the Avaloq backend/frontend interface Continue Reading
sort
Suboptimal Sort Calculation
Beware of the suboptimal sort cost calculation in SQL Server. Comparison with Oracle included. Continue Reading
IO Sort Cost Calculation (2)
Interpreting formulae; comparison to full table scan calculation Continue Reading
IO Sort Cost Calculation
IO Sort Cost Calculation: formulae and internals Continue Reading