Is there any overhead using views

I have created a view which massively speeds up a query, I would like to know if there is any overhead using views (perhaps when the record is added)

The query that is speeded up is, selecting a record from a table using many foreign keys. To get the values for the keys (integer) I look up against a text field, some of these lookup tables are 'large' 10000+ records. All fields do not allow nulls.

I don't understand why the view is quicker than the query (all the necessary indexes are in place), unless there is some sort of overhead when a record is added, in the same way that an index incurs an overhead when adding records, in order to maintain the index.

Basically I don't understand how views work and so I can't evaluate the pros and cons of using them.

Can anyone give me an explanation or a pointer to some information

thanks a lot
hugh. Received on Thu Dec 09 1999 - 05:12:12 CST