> > I'm still curious about why you need to use views for these...what
> is your client application environment?
>
> Hmm, I thought to use views instead of queries in my application
> environment (delphi) to speed it up...
> Or am I wrong on this?

What makes you think that a view would be any faster?
A view is a logical database object, not physical. Whatever view definition
you create, the view will still have to be deconstructed and data fetched as
if you were doing the original quer(ies).
The advantage of using views has nothing to do with performance but more
with providing data abstraction.

Regards
Paul Beach