JayceW
asked on
Improve Query Performance
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why does Excel need to be involved in this process?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
An Error in my joni criteria solved the issue but the comments were useful
ASKER
As you say I appreciate that they can be slow. This one however takes over 3 hours to complete so I am looking at potential ways to accelerate the query at the Worksheet\ MS Access database level.