>>How do you handle indexing your p-views? I want to maintain the incremental search and grid header click to set table/view order.
>
>You can create a temporary index on a view. In fact, the framework I use (Visual Extend) does this automatically, for the very purpose you mention. That is, if an index on the desired expression doesn't exist, the framework creates a temporary index. This works on tables as well as views.
>
>If your p-view fetched only 100 record out of the total of 100,000, only the 100 records have to be indexed (the view result, in this case, is a temporary table with 100 records!), so this is very fast.
>
In my case, the 100,000 records are split over about 12-15 locations, so it would be reasonable as a first guess to assume that the view size would be on the order of 5,000-10,000 records (for a "main" office possibly quite a bit higher, perhaps 20-30K), so indexing on-the-fly could become a performance issue. Do you agree?
BTW, I just read your FAQ on Rushmore. Very interesting.
Ray Roper