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
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
