Optimizing view performance: Avoid Expensive Columns
Hello All! In this installment of SATO Database Architects Blog, we'll show a little trick to improve performance on SQL views. Say what you will about views, but one thing is for sure...they are actually used. In a lot of places. And as you might have guessed, querying against view can be extraorginaliry slow. The performance hit can be pretty bad, if the view contains function calls, since they are invoked for each row. Amazing how lots of people do not realize this, but if