Indexing on views?

Hi I am working with 9.21 and Crystal Reports 7. I have created a view to base the report on but it takes quite a while for the report to appear. In general I have noticed that with views it does seem to take longer to access the data. The views are normally made up of a main table with Outer Joins to other reference tables, e.g. a sales table with joins to customer for name & address, etc. I think that the lack of performance may be due to problems with indexing, although all the tables are properly indexed in their own right. As far as I can see their is no way to create an index on a view, but does anyone have any ideas as to how to improve matters? Many thanks Ian Logan

Make sure the underlying tables have the correct indexes to support the view. Can you post a schema of the tables and the view? "Ian Logan" <ian.logan@straker.com> wrote in message news:bbhvl0$nk6$1@newsg1.svr.pol.co.uk... > Hi > > I am working with 9.21 and Crystal Reports 7. I have created a view to base > the report on but it takes quite a while for the report to appear. In > general I have noticed that with views it does seem to take longer to access > the data. The views are normally made up of a main table with Outer Joins to > other reference tables, e.g. a sales table with joins to customer for name & > address, etc. > > I think that the lack of performance may be due to problems with indexing, > although all the tables are properly indexed in their own right. As far as I > can see their is no way to create an index on a view, but does anyone have > any ideas as to how to improve matters? > > Many thanks > Ian Logan > >