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.
