Subject Performance issues with Views
Author Robert martin
Hi All

We have a number of Views which are unions on two tables. i.e.

AllInvoiceLines is a union of InvoiceLines and HistoricInvoiceLines.

These views are, mainly, used for reporting. However we have a number of reports (crystal 8.5) that now run incredibly slowly. We have traced the issue too reports the join two (or more) views to each other. Extracting the SQL from Crystal and running it directly to Firebird shows that the SQL takes tens of minutes to run. The data being used is not large.

Is this problem caused by views not having indexes etc? Is there a way to improve the performance of viewings in JOINs ?

Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
Wild Software Ltd

[Non-text portions of this message have been removed]