Viewing 3 posts - 1 through 3 (of 3 total)
I would say that the uniqueness of field1 and field2 are pretty good. For example, in one of my joins the fields were both US State codes. (Where a particular...
February 8, 2006 at 2:01 pm
#619622
Yeah, things are indexed as needed. The execution plan doesn't tell me much more than the regular join method does.
It is even slower than if it had to do...
February 8, 2006 at 11:20 am
#619589
Truth is, you don't even need the TOP 1 statement. If it is assigning to a variable, it will always only return one row.
October 25, 2005 at 8:03 am
#599803