Speed considerations with joins in views

From: <James_F_Davis_at_NSLC.FMSO.NAVY.MIL>
Date: 1995/04/04
Message-ID: <3ls4vo$5oi_at_news.fmso.navy.mil>#1/1


We have a number of tables which contain codes representing other data. To make it easy on users, we want to make a view which adds the descriptions of these codes. It will outer-join a table to lookup tables containing the descriptions. If a user accesses a view, but does not select a field from a joined table, does Oracle still perform the join? Does this hurt performance? Received on Tue Apr 04 1995 - 00:00:00 CEST

Original text of this message