I have some hand-rolled SQL that I use for cursor and/or view creation. Depending on what's in the WHERE clause, the result can be slow or undesireable.

Anybody got any thoughts on how to "pre-qualify" the optimization of queries before they are run (potentially too long)?

Thanks.