Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and table ?
- 13 Answers
- 74197 Views
- Deloitte, Renault Nissan, I also Faced
- E-Mail Answers
Answer Posted / baskar
VIRTUAL is an important word to be used that matches for
defining a VIEW. View just holds a pre-compiled query which
pulls records from a table or combination of joined tables.
A view can also be used to query which can then be used in a
view. So to define, A VIEW is a virtual representation of
data from real tables/views which is pre-compiled and
secured. The retrieval of records would be quicker in a view
than a table based query. The main usage of view is to hide
few columns from the table which you may not want to share
with the users who wants only the required and relevant data.
TABLE is a normal real time table which really hold data in
the database.
Functionality wise, we may not pass variables in a view and
order by clause cannot be used in a view.
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
What is sapnet?
Can i know some of the Realtime tickets that anyone has been faced ?
When will the current screen processing terminates?
What are the page windows?
1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?
Explain the types of bdc's?
How many tables are there in sap?
Reports: Event functionality.
What is asynchronous update?
What are the various types of selection screen event?
What is step-loop? Explain all the steps?
What are the advantages of logical databases?
Difference between domain and data element? What are aggregate object?
What kind of deliverables you have on a day to day basis?
What is the difference between table and template?
