I have a table of 80000 records. I have EmpID as a primary key. But I also need LastName to be indexed in order to speed up my query.
Can two fields be indexed? How do I do that?
This can be done easily. Go into design view on your table, and select the last name field. In the bottom left corner of the screen will be a row that says "Indexed". Change this to Yes (Duplicates OK), and save your table.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.