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 index?

Answer Posted / rad

An index is an oracle object that stores ROWID (pointer)
and columns(s) data on a source table. Two main types are
B-tree and Bitmap. An index is crucial as it can preempt
unnessessary full table scans on the source table if the
queried data is included the indexed column(s). B-tree
primarily useful in OLTP and Bitmap is DSS (generally..)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the attributes that are found in a cursor?

1045


What are the parameters that we can pass through a stored procedure?

1045


What is a oracle database?

1034


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2094


how do u setup a replication site?

1962


How to export several tables together?

1030


How to select all columns of all rows from a table in oracle?

1037


what is the difference between functional dependecy and multilevel dependency?

2444


What are the various types of snapshots ?

1009


What is the use of aggregate functions in oracle?

1012


State some uses of redo log files?

981


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1081


How to change program global area (pga) in oracle?

1069


Is there a function to split a string in plsql?

1039


Can you tell me how to add new column in existing views?how?How is possible?

1419