My program is using Access mdb database through ADO. I have Access installed here, but there is no Access on that machine which has the database. There is a query, which takes much more time than it should...
My question is:
- How can I profile that query (under Access of course) to find out why it needs that time for, which indexes were used, and why they were or weren't used?
- Can I profile on a remote comp over ADO and save the results with a diagnostic program, so I don't have to move the big database?
- Can I view or export the table or the table structure under Access to pure SQL script to see whether the indexes have been set correctly? (I already have a 3rd party program, but it may not be accurate enough.)
Thanks for your answers!