John,

The key (pardon the pun) is that both fields need to be character type in the index expression for the index to be meaningful. In the index expression (under MODIFY STRUCTURE) you simply put field1+field2 to concatenate them into the key.

If one of the fields is a date, you can use dtos(), for example:

index on cfield1+dtos(dfield2) tag tag2

Creating an index tag containing more than one field does not help for Rushmore purposes. If you need to run queries that involve these fields in the WHERE clause, you need an index on each indivual field for Rushmore to kick in (with regards to those fields).

>up until now i have created indexes when creating the table, but need to create an index on 2 fields and can't find any unconfusing stuff in the help... many thanx!