Yah, but what if the reason you're trying a "USE PLAN" is because the optimizer simply won't come up with a reasonable solution.

Here's an example.

Table A: (createdDate datetime, id...

Hi Matt,

I never thought that this was a .NET problem. I was only complaining that Microsoft didn't allow the CLR the option of being integrated into the database engine itself...

Barry,

Thanks for your informative post. I saddens me that 10 years after Informix bought Illustra and merged their solution into that database platform, Microsoft still hasn't caught up. Even in...