- #51
DrJohn
- 212
- 192
Why not ignore the views and query the table they are formed from? A view is not a real table, so the view has to be created by its own query, and you are doing that several times. then joining them. Query the source of these views directly, so no join is required. However, are the views indexed? The index should be stored. But the index to the table of origin should be stored as well, so querying that should be faster as no join would be required.
Views are usually created to give office staff easy access to just the data their level of expertise or position in a company allows, or to avoid errors when they repeatedly enter a query with an extra column or two being required.
Views are usually created to give office staff easy access to just the data their level of expertise or position in a company allows, or to avoid errors when they repeatedly enter a query with an extra column or two being required.
