I am working with SQL quieries in the jet 3.0 through ODBC. Things
work out fine, but there is some optimization issues I would like to
know more about! If you have knowledge about some of the issues listed
below, and wants to share/discuss them with me, please email me.
- How do the jet really find the matching records. (Rushmore ?)
- How to index the database to optimize sql-queries ?
- How to optimize free-text search ( with the LIKE statement)
Ulf Erik Forsbakk
VB homepage (norwegian): http://www.forum.no/home/wolf/vb.htm