>How can I make a grid faster using a 200000 record table but only
>10 to 20 record will be selected out depend on a master key value ?
>
>I have try to use set filter ( think that it will use rushmore, but the result is not). The grid is very slow.
>
>Now I am using SET KEY RANGE. to make to work faster.
>
>Other than SET KEY RANGE, Can I use view to do it ? How is the speed to create view of the above case. Will it use Rushmore tech ?
>
>
>thanks

Yes, it uses rushmore. Getting 100000 record result set out of 1 M is nothing but a split 5.7 seconds using rushmore...

SQL VIEWS is the best option in getting result set rather than SET FILTERS...