Evelyn,
>The base table of the view currently contains 370,000 records. All other info come from three other chilldren tables. All the tables are Rushmore optimized to my knowledge. I am sure that some of you deal with larger tables. How do you get around this problem?
Do you have index tags on DELETED() in these tables? Recent threads here have had examples of dramatic speedups after removing the DELETED() tags.