>Thank you Hilmar for the quick respose!
>
>SET KEY TO does not improve the performance over SET FILTER TO. I will see how a paramitized view does.
>
>Dawa
I don't use SET KEY myself, but included it for completeness sake. Several other programmers mentioned this as an alternative. I don't know why it doesn't help in your case - but I wouldn't use it for other reasons. Mainly, the advantage of a p-view, to use temporary indices (SET KEY relies on an active index).
A parameterized view helps a lot, in terms of speed, and I try to use it as soon as my form works with an underlying table of 20,000 records or more.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
