topic Re: Problem about the Execution Time in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problem-about-the-execution-time/m-p/2711996#M628743 <HTML><HEAD></HEAD><BODY><P>Such a generall question does not really make sense</P><P></P><P>A view can be a project, i.e. one table with less fields, the effect will be the same</P><P>as using a field list. Just simpler to code.</P><P></P><P>A view can be a join of several tables, usually from performance the same as the join, just simpler to code.</P><P></P><P>In rare case a view can be materialized, it exists on the database and not just as defintion. Recommended only in ver y exceptional cases, can make problems!</P><P></P><P>Siegfried</P></BODY></HTML> Mon, 13 Aug 2007 10:24:28 GMT Former Member 2007-08-13T10:24:28Z Problem about the Execution Time https://community.sap.com/t5/application-development-and-automation-discussions/problem-about-the-execution-time/m-p/2711995#M628742 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P></P><P>If we fetch data from view and fetch it directly from database table</P><P>Does it make any difference in Execution Time.</P><P></P><P>If yes, then which one is preferable way for fetching data.</P><P></P><P>If anybody give me some guidance for fecthing data which will take less execution time, it is really very helpful to me.</P><P></P><P>Thanks in advance,</P><P>Dharmishta</P></BODY></HTML> Mon, 13 Aug 2007 10:12:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-about-the-execution-time/m-p/2711995#M628742 Former Member 2007-08-13T10:12:34Z Re: Problem about the Execution Time https://community.sap.com/t5/application-development-and-automation-discussions/problem-about-the-execution-time/m-p/2711996#M628743 <HTML><HEAD></HEAD><BODY><P>Such a generall question does not really make sense</P><P></P><P>A view can be a project, i.e. one table with less fields, the effect will be the same</P><P>as using a field list. Just simpler to code.</P><P></P><P>A view can be a join of several tables, usually from performance the same as the join, just simpler to code.</P><P></P><P>In rare case a view can be materialized, it exists on the database and not just as defintion. Recommended only in ver y exceptional cases, can make problems!</P><P></P><P>Siegfried</P></BODY></HTML> Mon, 13 Aug 2007 10:24:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-about-the-execution-time/m-p/2711996#M628743 Former Member 2007-08-13T10:24:28Z