How to create an index

A

alish

Please tell me how to create an index in a db table that way it speeds up my
searching. Thanks.
 
K

Kerry

Please tell me how to create an index in a db table that way it speeds up my
searching. Thanks.
Click to expand...

Open the table in design view
Select the field name you want to be indexed
On the field properties at the bottom on the General tab change
Indexed to Yes (Duplicates OK)
 
J

Jeff Boyce

To speed up your queries, try indexing (in your table structure) on the
fields you use (in your query) for:
* joining tables
* selecting values (selection criterion)
* sorting

You may need to do some experimenting. Consider reading up on Indexing --
not every field used as above is a good candidate for indexing.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Top