0 - 2 of 2 tags for collecting statistics

Hi. I've been reading this forum for some time now but it's the first time I'm posting anything. I have a question regarding the collection of statistics when it comes to Join Indexes.

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.