I have a a Excel 2007 spreadsheet that using SQL queries from an Oracle database. I then use MS Access 2007 linked tables to retrive data from this workbook and to create further queries. I then use Crystal Reports 8 to report on the Access database using a simpe filter and sub reports. As you would imagine this query is quite slow.
What is the best method\ syntax to add indexes to either or both the Excel spreadsheet and MS Access database to improve performance. I do not have update capability on the Oracle database.