topic Re: database view in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897236#M681160 <HTML><HEAD></HEAD><BODY><P>Database views are implemented with an equivalent view on the database.</P><P></P><P>Database views should be created if want to select logically connected data from different tables simultaneously.</P><P>Database views implement an inner join.</P><P>Application programs can access the data of a database view using the database interface. (Just as we write select queries on database tables, we can write them for views as well.)</P><P></P><P>So when you execute view, it executes the definition.This definition execution is taking a long time. Which db view are you executing?</P><P></P><P>ashish</P></BODY></HTML> Tue, 16 Oct 2007 18:24:30 GMT Former Member 2007-10-16T18:24:30Z database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897235#M681159 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P>when i am executing the database view(contents)..</P><P>its taking so much time.</P><P></P><P>what is the reason..and i am giving max no.of hits are only 10.</P><P></P><P>why its taking so much time.</P><P></P><P>pls. anyone explain.</P><P></P><P>regards,</P></BODY></HTML> Tue, 16 Oct 2007 18:20:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897235#M681159 Former Member 2007-10-16T18:20:33Z Re: database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897236#M681160 <HTML><HEAD></HEAD><BODY><P>Database views are implemented with an equivalent view on the database.</P><P></P><P>Database views should be created if want to select logically connected data from different tables simultaneously.</P><P>Database views implement an inner join.</P><P>Application programs can access the data of a database view using the database interface. (Just as we write select queries on database tables, we can write them for views as well.)</P><P></P><P>So when you execute view, it executes the definition.This definition execution is taking a long time. Which db view are you executing?</P><P></P><P>ashish</P></BODY></HTML> Tue, 16 Oct 2007 18:24:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897236#M681160 Former Member 2007-10-16T18:24:30Z Re: database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897237#M681161 <HTML><HEAD></HEAD><BODY><P>Hi Venu,</P><P></P><P>Check whether you have JOIN condition on primary key of tables. Sometimes it will take lot of time if you have JOIN condition on non-primary key values.</P><P></P><P>Thanks,</P><P>Vinay</P></BODY></HTML> Tue, 16 Oct 2007 18:25:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897237#M681161 Former Member 2007-10-16T18:25:30Z Re: database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897238#M681162 <HTML><HEAD></HEAD><BODY><P>Would you post the code please?</P><P></P><P>Rob</P></BODY></HTML> Tue, 16 Oct 2007 18:26:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897238#M681162 Former Member 2007-10-16T18:26:36Z Re: database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897239#M681163 <HTML><HEAD></HEAD><BODY><P>Hi Ashish,</P><P>it is a zview .. not standard view...</P><P>the zview is created bt 3 tables ..</P><P>that are cobk , coep and CE4HINC_ACCT tables..</P><P></P><P>i am executing this vew directly.. its exection time very slow.</P><P></P><P>help me.. what is the reason.</P><P></P><P>regards,</P></BODY></HTML> Tue, 16 Oct 2007 19:14:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897239#M681163 Former Member 2007-10-16T19:14:19Z Re: database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897240#M681164 <HTML><HEAD></HEAD><BODY><P>Would you post the code of the SELECT statement from your program?</P><P></P><P>Rob</P></BODY></HTML> Tue, 16 Oct 2007 19:16:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897240#M681164 Former Member 2007-10-16T19:16:38Z Re: database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897241#M681165 <HTML><HEAD></HEAD><BODY><P>hi rob,</P><P>i am not executing the view from report.</P><P>i am exceting view directly..</P><P>it is taking so much time..</P><P>in this view .. there are 3 tables are used.(joined)</P><P></P><P>regards,</P></BODY></HTML> Tue, 16 Oct 2007 19:21:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897241#M681165 Former Member 2007-10-16T19:21:13Z Re: database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897242#M681166 <HTML><HEAD></HEAD><BODY><P>Then what are the join conditions for the view?</P><P></P><P>Rob</P></BODY></HTML> Tue, 16 Oct 2007 19:23:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897242#M681166 Former Member 2007-10-16T19:23:01Z Re: database view https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897243#M681167 <HTML><HEAD></HEAD><BODY><P>COPA tables contain huge data. you need to be very specific while joining the tables.</P><P></P><P>Please check JOIN conditions. And try to be as specific as you can by adding more conditions.</P><P></P><P>ashish</P></BODY></HTML> Tue, 16 Oct 2007 19:36:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/2897243#M681167 Former Member 2007-10-16T19:36:01Z