>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