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

How to speed up webrick?

1119


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5671


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2544


What is dynamic proxy?

1047


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2063


How to use "in" parameter properly?

1115


How to divide query output into groups in oracle?

1029


What is meant by joins? List out the types of joins.

1101


How to use values from other tables in update statements using oracle?

1119


How to list all tables in your schema?

1113


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1991


How to use an explicit cursor without open statements?

1097


What to do if dba lost the system password?

1243


Explain cascading triggers.

1118


Can a formula column be obtained through a select statement ?

2377