Re: Performance of Views

alainkr wrote:

> Hello all,
>
> I need your advice for the following problem :
>
> I'd like to use a view for a query that is repeated througout our
> code. That query has 7 joins. From a developer I'd really like that.
> It would prevent each developer from aliasing with different name etc.
> I'm affraid of performance problem since that view would be against a
> quite large table 3,000,000 records / year
>
> A ran an execution plan for both (using the view and using tables)
> there're obliously identical. Now does that mean that I won't have any
> more performance problem with the view that without.
>
> I apreciate your help.
>
> Alain.

I would not expect this will cause any major problems.

But I always reserve the right to change my mind when reality proves otherwise.

Daniel Morgan Received on Tue Oct 01 2002 - 10:33:33 CDT