Re: Any reason not to combine several views?

From: Chris McFadden <cmcfadde_at_mitretek.org>
Date: Thu, 11 Mar 1999 17:16:30 -0500
Message-ID: <36E840BE.41437F0D_at_mitretek.org>


In an oracle only environment the query optimizer will probably ensure that only the columns needed are retrieved. using ODBC might be a different story. But in general you are introducing additional overhead which will affect performance to some degree. You might want to try some tests.

chris

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
 http://www.newsfeeds.com/ The Largest Usenet Servers in the World!
-----------== Over 66,000 Groups, Plus a Dedicated Binaries Server ==----------
Received on Thu Mar 11 1999 - 23:16:30 CET

Original text of this message