Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

) Is VIEW occupies any space in database?

Former Member

‎09-20-2007 4:24 AM

0 Kudos

) Is VIEW occupies any space in database?

2 REPLIES 2

Former Member

‎09-20-2007 4:27 AM

0 Kudos

Views are just another way of looking at data from the database. For example say that there is a database table with 100 fields and you only need to see 10 of the fields. In a view you would define the table where the data comes from and those 10 fields that you want to see. When doing select against this view, the database processor will take a look and see what fields are defined in the view and select only those fields instead of all the fields. You can also define in the view, certain selection criteria, also you can join other tables. You create views via SE11. Only view definition is stored, data is displayed at runtime from database tables associated to each view.

http://help.sap.com/saphelp_40b/helpdata/en/cf/21ec5d446011d189700000e8322d00/content.htm

Former Member

‎09-20-2007 5:20 AM

0 Kudos

hi,

No, views are not occupy any space in the database.

It is only a fecth query, which will show the required result when gets executed.

thanks

Dharmishta