>>I think a good tip too is don't overdo it on indexes. I have seen some aps with 20 tags of more on some of the files... This actually causes more network traffic espessially with rushmore turnd on. Generally two indexs, a PK and a Candidate Key should be adequate. Other than that, use more order by and client side indexes.
>>
>>BOb
>
>What do you mean by your last sentence? Do you mean "SET ORDER TO"? Don't you have to have an index for that? What are "client side indexes"?
>
>Thanks,
>
>Michelle

No... "Order By" clause in your views and/or queries. You can also create an index on a view or cursor made read-write.

BOb