>>>> Thanks in advance.
>>>Yes Creating the view on the fly should be faster
>
>I would test this first- creating a view on the fly and setting a bunch of view properties can take a while...
>
>>>Then, when you want to delete the view:
>>>USE IN Nadya
>>>DROP VIEW Nadya
>
>You should know that doing this repeatedly will results in a continually growing dbc file- Each time you create a new view and delete it, a record is added and deleted.
Thanks a lot, Erik.
I won't probably delete the view. I'll better keep it in the database and use in other applications.
If I have ~5000 records and I want to filter just 200 of them, I think, filter approach would be slower than view. I will test it today...
If it's not broken, fix it until it is.
My Blog