Hi
1. what is the diff b/w inner join and outer join
The data that can be selected with a view depends primarily on whether the view implements an inner join or an outer join.
With an inner join, you only get the records of the cross-product for which there is an entry in all tables used in the view.
With an outer join, records are also selected for which there is no entry in some of the tables used in the view.
Database views implement an inner join. The database therefore only provides those records for which there is an entry in all the tables used in the view. Help views and maintenance views, however, implement an outer join.
Have a look at these links:
2. what is index and use
You can speed up a table search for data records that satisfy certain search criteria by using an index. You can create more than one index for a table.
In addition to the primary key, which you define in the ABAP Dictionary when creating a table, you can also define additional indices (called database indices) for transparent tables. Using indices, you can improve the time needed to access and read your database table.
An unique index ensures that no duplicates are entered in a table.
Have a look at this link:
<a href="http://help.sap.com/saphelp_nw04/helpdata/en/c7/55833c4f3e092de10000000a114027/frameset.htm">http://help.sap.com/saphelp_nw04/helpdata/en/c7/55833c4f3e092de10000000a114027/frameset.htm</a>
Regards,
Gunasree.
Please Award marks For Helpful Answers.
Bluesky
