RE: Is a view efficient in joins?

2009-11-29 Thread Neil Aggarwal
Jim: > A view is no more or less efficient that the queries that > make it up. Each > time you invoke the view, you repeat all the joins. That is what I was afraid of. With the large number of tables I have, the joins are going to take a lot of cycles to run. > Your solution of the summary ta

Re: Is a view efficient in joins?

2009-11-29 Thread Jim Lyons
A view is no more or less efficient that the queries that make it up. Each time you invoke the view, you repeat all the joins. A join could be more efficient only if you go to a lot of effort to ensure it forms the most efficient join(s) of the underlying tables. Your solution of the summary tab