Bob, I often create a set of hierarchical views, with the underlying views
restricting the data set before I combine the "lookups". I suppose I'm
just forcing R:Base to optimize my way by doing this, but it works for me
----- Original Message -----
From: "Bob Powell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 9:41 AM
Subject: Best way to manipulate information
>
> Hello Everyone:
>
> Does anyone know if there is a document that
> explains the BEST way to deal with tables and views? What
> I mean is... is it better to create a view that is
> comprised of numerous other tables or views rather than
> projecting tables and then combining them in a table or
> final view that contains the final result? Are there any
> hard fast rules anywhere or is it just based on the
> structure of the database and what you are currently
> attempting to do?
>
> If you have a view that contains 6 tables is it
> better to let's say project three preliminary tables that
> you then combine with a view rather than using a view to
> combine all 6 tables initially? Hope I'm making sense.
> Anyone done any testing on this?
> ----------------------
> Bob Powell
> The Hotchkiss School
> Lakeville, Connecticut
> Systems Administrator
> [EMAIL PROTECTED]
>
