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.