>Hello Doru,
>
>>>
>>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).
>>
>>Are you sure about that? I believe that if you use the exact index expression in the WHERE you get full optimization.
>
>Hmmm...good point. I don't tend to concatenate fields together in the where clause. I suppose you mean like:
>
>
>select * from table1 where cfield1+dtos(dfield2)="abcd1 "+dtos(date())
>
>I guess this would be optimized (maybe someone will chime in), given the above index expression. I would normally construct the query like the following, which would require a separate index on each field:
>
>
select * from table where cfield1="abcd1" and dfield2=date()
It's easier to write WHERE on non concatenated fields, but sometimes you only have (or need) a concatenated index on the table. I use it a lot, and I'm almost positive Rushmore works on concatenated expressions - SYS(3054) reports full optimization and the result comes back instantly.
Doru