>Does Rushmore technology have any effect on these indexes and if they are not permenant what are they effects or limitations on updating tables that use these indexes?
Yes, Rushmore technology is used on the remote views when indexes are created. But you don't get a great advantage from Rushmore until you start dealing with large record sets. And if you are working with large record sets, you need to have a good reason < g >. Generally, you want to pull as little data as necessary across the wire. Generally, I just index my remote views to sort the data in grids or reports.
Chris McCandless
Red Sky Software