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...

Differnce between view and index

Answer Posted / sahaja mallarapu

A View is a data base object also called as virtual table
which is created on a select statement.
A view can be created using multiple tables.
A view is stored in a temporary memory.

An index is also a DB Object which is used to increase
query performance and index is created based on columns of
a table.
An index is created on multiple columns but on a single
table.
Index is maintained by Oracle Server itself.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I spool in oracle?

952


Explain a segment?

1033


What is open database communication (odbc) in oracle?

960


Who developed oracle & when?

956


What is dual table oracle?

932


What do you mean by cdb and pdb in oracle 12c?

1014


Will you be able to store pictures in the database?

1072


What suggestions do you have to reduce the network traffic?

909


How to recover a dropped table in oracle?

988


How many types of table in Oracle?

1075


What is a sub query? What are its various types?

1092


What happens if you lost a data file?

989


How to retrieve values from data fields in record variables?

1047


What are the differences between char and varchar2 in oracle?

1088


What is bulk collect in oracle?

960