Compound Indices

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

If I create a compound index on a table with, say, 2 columns in the index,
then join it to another table using both columns, will Access automatically
use the index, or is there some other way I should do that?
 
To really know if Access uses an index, Google "access showplan". It tells
you how queries are actually run. Always us the results from the second time
a query is run after being created or modified.
 
Back
Top