Re: view bad performance

Sven Köhler <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
> 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.

The view is executed and the result-tables is used (i guess).

> It wanted to know if i to have change some parameter or some other solution.
> thanks

You could always relate to a table since it naturally faster than 
relating to a view in SAPDB.

BTW: what do you mean by "realted to a view"? do you mean a JOIN in you 
select? or can't imagine that SAPDB allows foreign-keys on view-tables.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.