Performance of Views

From: alainkr <akreienbuhl_at_yahoo.com>
Date: 1 Oct 2002 07:54:23 -0700
Message-ID: <9822b77f.0210010654.13456cb8@posting.google.com>

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. Received on Tue Oct 01 2002 - 09:54:23 CDT