Here's a clever way to force the query optimizer to follow the same *stable* plan for a query regardless of the data set it runs against. Useful when the data set cardinalities and row count profiles are well understood. Also useful when ID numbers increase and the query optimizer would have to extrapolate past the right-most interval.
An added benefit is the abilty to add new statistics on terabyte size tables in just a few minutes. Query tuning can proceed rapidly.
Is anyone doing something like this or accomplishing it another way?