Hi all,
I have created a number of materialised views to help improve the reporting from our database. Writing reports from these views is now very simple and is also extremely quick in both running and exporting....
However, as soon as I link the view to another table the report is very slow at exporting.
I am therefore thinking that Indexing the views could possibly improve this but I do not really have any idea how to do this.
For info, there are 2 fields in each of the views that I use for linking - person id and case reference number.
Can anybody comment on whether indexing is the way forward or is there anything else that should be considered.
Any help greatly appreciated.
Chris
IP Logged
