>>you can look at a C statement and be pretty sure what the ASM will end up looking like. Perhaps 20 years ago, perhaps more. Optimizing compilers have gone lo

>>you can look at a C statement and be pretty sure what the ASM will end up looking like. Perhaps 20 years ago, perhaps more. Optimizing compilers have gone long way. Compiling an execution plan is a significantly easier task than actually guessing how exactly an optimizing compiler would schedule the code, down to assembly. (and cheating w/ hints in SQL- [looking at Oracle]just reinforces that.)