Re: view bad performance

Not really.  As sven indicated it's related to the way SAPDB handles 
queries on views in some cases. Due to that fact we have begun to remove 
view from our most important application as in almost all nontrivial 
cases the performance is just unacceptable compared to formulating a 
query that yields the same result without  views. After having worked 
with views for a while now I would not advise anyone to use them for 
cases where perfomance is an issue. Even if one query involving views 
might be fast, you might run into the next one that's terribly slow 
which is from my experience quite unpredictable. This has been mentioned 
and acknowledged on this list a few times but it does not seem to be a 
high-priority issue at SAP. I would label the current view 
implementation proof of concept and keep away from it for serious work 
as in most cases I've encountered the price you pay is much higfher than 
the gain.

just my 2c

Regards,

Robert

Nestor Rojas wrote:

> Hello
> I have a query that contains a table related to viewa,
> the performance is bad,
> but if I relate that same table to the table that contains the view
> is fast.
> It wanted to know if i to have change some parameter or some other 
> solution.
> thanks
> Nestor Luis