Hi Frederick,

Try using views like David suggested. If you find it is still slower, your best bet is to set the relations between the Parent and the child table in the DE and locate the right record in the Parent table, then refresh the grid which holds the child table.

>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