The Axis Of Evil
Views, table variables and local variables are great in terms of programming principles. But In terms of performance, they can be a honey trap: They don’t scream “DANGER!” like cursors or user defined functions, but they can cause serious problems very easily. That’s why I call them “The Axis Of Evil”. I know – maybe it’s a little extreme, but let me explain. Why Views Are Evil The truth is they are not. It’s the way people sometimes use them that is evil. Views are great for