How to create Index

A

alish

Can anyone tell me how to create index on a table so that it makes my
searches quicker. thanks.
 
B

Beetle

Open the table in design view and select the field you want. In the general
properties tab you will see the "Indexed" property. You can change it there.

HTH
 
P

Pieter Wijnen

Query SQL:
CREATE INDEX myIndex On MyTable (myField)
or for unique index
CREATE UNIQUE INDEX myIndex On MyTable (myField)
or for primary key
CREATE UNIQUE INDEX myIndex On MyTable (myField) WITH Primary

You can also go into table design, locate the indexes button on the toolbar
& do it Wysiwyg

HtH

Pieter
 
Top