By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,390 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,390 IT Pros & Developers. It's quick & easy.

How to get the most efficient SQL with ODBC

P: n/a
I have an application running on a client PC using linked tables on a
server and linked ODBC tables on a Unix legacy system. One particular
query joins an Access table with 3 ODBC tables. The tables are all
"efficiently" indexed but I have found that to get the quickest
response I must have a selection criteria on the access table even
though I need to select all the records in this table.

Has anyone got any other "rules" about efficient SQL statements that
are not already available in the Access help.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.