 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2009Compound Indices
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?  SignatureJim > 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? Yes. In most RDBMS the first column in the index is usually used as the main search part of the index. The second column is a "secondary" index. So make sure the first column is something you'll use a lot - as JOIN columns or criteria columns. HTH, SignatureMGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA) ** Respond only to this newsgroup. I DO NOT respond to emails ** 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. SignatureJerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > 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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.