Is there performance reasons to use views?
I realize this answer might be different per database. I'm using MS SQL but am curious about any database really. Does a view in general cause a performance optimization over its raw sql query equivalent?
Only thing I can think of is the select string size itself sent to the server... which is almost never a factor that anyone cares about.