Re: Views with Joins

Tim,

>Other than putting a groupby aggregation in a view, is there a way
>to force a view to be fully instantiated before it is joined to
>another view or table?

If you're working with 7.3 or above, try the hint NO_MERGE.

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---