Virtual Indexing Part 7: Finite Opposite Numbers
Virtual Indexing continues…How do we to avoid sorting in either direction (ascending and descending)?
Virtual Indexing Part 6: Combinatorial Index Optimization
In Part 5 we learned how to return a distinct set of numbers from a one Billion row table in under 1/10th of a second. We can do better!
Virtual Indexing Part 5: The Multidimensional Virtual Index
In this installment of the Virtual Indexing series we’ll examine how to combine indexes to return a distinct set of numbers faster than using GROUP BY or DISTINCT