topic Re: Diff between database view and inner join in Application Development and Automation Discussions

Diff between database view and inner join

Former Member — Wed, 17 Jun 2009 16:15:10 GMT

Hello,

I need to select data from multiple tables. I need to choose between 2 options.

1) create a database view and use this view for select.

2) write an inner join in abap prorgam.

In which cases we should create a view and in which cases we should use a inner join?

What are the factors which decide these?

Pls advice.

Thanks,

Rupali.

Re: Diff between database view and inner join

Former Member — Wed, 17 Jun 2009 16:20:43 GMT

Hi,

Both are same..

But if you use regulary and used view in Multiple programs then create view..

If inner join in abap prorgam between two or more table used in less Programs and do not want to

create View (Means not to create transport request) then go for JOin in Program.

Prabhudas

Re: Diff between database view and inner join

HermannGahm — Wed, 17 Jun 2009 16:47:24 GMT

Hi Rupali,

besides REUSE as pointed out by Prabhudas:

Views can be buffered in the SAP table buffers.

Execution times on the database are the same for views and joins.

Kind regards,

Hermann

Re: Diff between database view and inner join

Former Member — Wed, 17 Jun 2009 18:11:33 GMT

To use a view or a join depends on how frequently are you going to use the program and how big the tables are. Views are data dictionary objects and hence will occupy some memory. So if the program is not used that frequently or if the view created may not be useful for other programs, then better use inner join.

Re: Diff between database view and inner join

Former Member — Wed, 17 Jun 2009 18:25:08 GMT

Thnks!