Alastair,
I've come to use views as much a possible, there is just to much
efficiency and flexibility in maintenance not to. That said, there are
situations where the view is too unwieldy to be used exclusively
and lookups are more appropriate.
Ben Petersen
On 21 Jun 2001, at 15:06, Alastair Burr wrote:
> Does anyone have any opinions on or experience of the speed and/or the
> efficiency of views and look-ups when running reports?
>
> For example:
>
> Is it better to create a view that contains only the linked base data (eg: ID
> and code numbers) and then do look-ups (eg: names and other text) when running
> the report,
>
> or
>
> is a more complicated view with all the relevant columns included better so that
> no look-ups need be done when the report is run?
>
> Is there any point where choice might be different - high number of tables in
> the view against low number of look-ups or vice versa, perhaps?
>
> (The physical printer is irrelevant as I am saving the results to a file.)
>
> Regards, Alastair.
>
>
>
