When you select from views, you are infact selecting from the
underlying tables. Indexes created on those tables are used
ultimately.
--Imad
www.EnterpriseDB.com
On 11/4/06, Dylan Lorimer <[EMAIL PROTECTED]> wrote:
Hi,
If I've got several tables, each with their own indexes. I also have a view
that aggregates several of these tables. My question is, as novice-like as
it may sound, do I need to create new indexes on the view or do the indexes
from the orig. tables apply somehow when I select data from the view?
Cheers,
Dylan
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
