compound index

  • Thread starter Thread starter taccea
  • Start date Start date
T

taccea

How do I creat a compound index?
I need to have an index that included 3 fields,
one is textual and the other two are numerical.

any guidance appreciated

taccea
 
While in table design view, hold down the CTRL key and click the fields.
Then click the "key" icon in your menu bar. You can use the view menu to
view "indexes" if you wish to see the compound key and change any of the
properties.

Rick B


How do I creat a compound index?
I need to have an index that included 3 fields,
one is textual and the other two are numerical.

any guidance appreciated

taccea
 
If you want to make a compound Primary Key (and I suspect that IS what you
were asking), the way Rick described is what you need to do.

However, if you already have a PK and you want a *separate* compound index,
you have to do something different.

Open the table in Design View. Click the Indexes button (it has a lightning
bolt on it). Go to the bottom of the list to a blank line and type a name
in the IndexName column. Then select a field to index. Now, on the next
line, choose another field WITHOUT giving it an index name. Do the same for
the last field. This will create a compound index.

If you select the first line in the index, you can set properties for the
index like: Unique or Ignore Nulls. If you click any other line in the
index, these options won't be available.
 
Gracias !!!

Taccea
Roger Carlson said:
If you want to make a compound Primary Key (and I suspect that IS what you
were asking), the way Rick described is what you need to do.

However, if you already have a PK and you want a *separate* compound index,
you have to do something different.

Open the table in Design View. Click the Indexes button (it has a lightning
bolt on it). Go to the bottom of the list to a blank line and type a name
in the IndexName column. Then select a field to index. Now, on the next
line, choose another field WITHOUT giving it an index name. Do the same for
the last field. This will create a compound index.

If you select the first line in the index, you can set properties for the
index like: Unique or Ignore Nulls. If you click any other line in the
index, these options won't be available.
Click to expand...
 
Back
Top