>>1. I am accessing the data locally.
>>2. The total number of records is 7,127.
>>3. The speed is approximately 17 seconds with this data set.
>>
>
>Did you tried to delete tags all and add them one by one by adding a new condition? 17 sec. seems too long for me. It should be 1-3 sec. Did you try it on different machines?
>
>>>Did you access this table locally or through the network? What's the number of records in a table and what speed do you get?
>>>

<snip>

The last thing I tried was to create a simple index which would return 20000 records. This test CDX contains no other indexes other that the one index. I ran a test on this one index and it still took 27+ seconds on my machine.