Viewing 2 posts - 1 through 2 (of 2 total)
Well this is a matter of how the execution is planned on the server.
I suggest to do an analysis of that execution plan for those 2 queries.
Im guessing there are...
July 22, 2004 at 8:51 am
#515703
As mentioned above your select is filtered more in the second clause. My thumb rule when i write sql is that i put the clause that limits my select most at...
July 22, 2004 at 8:41 am
#515699