Is using views always slower than using base tables?

Is using views always slower than using base tables, at least theoretically? My developers ask me to create views for them. I told them views are used for two purposes: for convenience so that you don't have to remember or type in all the base tables and their column names; for security so as to hide some column or table names. My developers are not end users. They don't need the convenience and they should be allowed full select privilege on base tables. For performance reason, views are always slower than or indistinguishably the same as using base tables. Is this correct?

Yong Huang
yong321_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jul 06 2000 - 00:00:00 CDT