| performance of views [message #372937] |
Mon, 19 March 2001 12:34  |
Mike Oakes
Messages: 25
Registered: December 2000
|
Junior Member |
|
|
Hello,
Can someone confirm my thinking here. Do views use indexes from the tables that are being used to make the view. I am having performance problems in my view. The field I am using as criteria to search the view is not indexed in the related table.
If I create this index should this improve performance, or does it not matter because views do not use indexes.
Thanks for your help
|
|
|
|
| Re: performance of views [message #372985 is a reply to message #372937] |
Tue, 20 March 2001 20:01  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
|
Views always have some overhead, and can be quite problematic when you have group functions in the them (sum, max etc.). Normally the where clause you specify when you query the view is merged with the where clause in the view (if you have one). With the group functions, the resultset of the view must be completed before your where clause is finnaly evaluated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
