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
