Hi Grant,

Yes it was in NYC! I talked with you briefly on Saturday, in fact. Nice to put a face to the message board login!

Nobody at SQL Saturday was proposing the extensive metrics that I'm referring to in my post.

However, in Thomas Larock's presentation, he talked about measuring selectivity for various conditions (such as JOINs) in your queries, as part of a query optimization process. I assume this is a fairly standard practice. The reason for my post is that I didn't/don't understand whether to measure each predicate individually, or group them together when measuring, or both.

I am also not suggesting that I would ever do all these metrics. I simply want to know which ones to do. I hope this clarifies a little...

Jordan