Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between view and table ?

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


Please Help Members By Posting Answers For Below Questions

What are the modes in which any update tasks work?

1044


There is 1 person but it’s displaying that this person cannot be booked. He is not available for the business event. Can you tell me where is it going wrong? What can be the reasons? : sap abap hr

1007


What are the aggregate objects in the dictionary? : abap data dictionary

1130


When was the sap abap being created?

1073


Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc

1153


What are indexes? : abap hr

1052


What is append search help? : sap abap data dictionary

1123


In which cluster time results are stored? : abap hr

993


What are the page windows? How many main windows will be there in a page window?

919


What is dialog module?

1006


Explain the types of bdc's?

955


What are spa/gpa parameters (sap memory)?

1191


How to read 5th record from Hash Internal Table?

1288


What are the user groups?

956


What is the difference between bdc_open_group and bdc_open_dataset. : abap bdc

1095