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

  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

WHAT IS INDEXING?

Question Posted / shazumca

Answers were Sorted based on User's Feedback



WHAT IS INDEXING?..

Answer / savithri

A database index is a data structure that improves the
speed of operations in a table. Indices can be created
using one or more columns, providing the basis for both
rapid random lookups and efficient ordering of access to
records.

Is This Answer Correct ?    6 Yes 0 No

WHAT IS INDEXING?..

Answer / sunny sarin

Indexing is creating an index for a table in the database to
fasten the speed of retrieving the results and for better
performance and efficiency.
Normally,indexes are of 2 types
unique
non-unique

unique index is created implicitly by the server whenever
any primary or foreign key constraint is given to any
column/s in the table.

we can also create a non unique index for any column in the
table.

indexes are stored on a different segment than the
table,this reduces contention on the table

indexes should not be created for that columns for which the
value in the column varies a lot.

indexes should also not be created on the columns on which
high level of DML's and DDL's are performed.

Is This Answer Correct ?    1 Yes 1 No

WHAT IS INDEXING?..

Answer / pppandu

It Is One Of The Database Object,Which Automatically
Created While Creating The Primary Keys Those Gives More
Performance

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Database Management Interview Questions

What is relational database ? Give me an example !

4 Answers   NetApp,

Mention the differences between union and union all

0 Answers  

Describe the four types of indexes.

0 Answers  

What are five types of database models?

0 Answers  

How to know the Architecture of the Database

0 Answers   HCL,

What are the different types of data tables?

0 Answers  

How do databases help businesses?

0 Answers  

How do you set up a database?

0 Answers  

How to migrate paradox, dbase or foxpro database to firebird?

0 Answers  

What are ACID properties?

11 Answers   Amazon, Cap Gemini,

does pl/sql support “overloading”? Explain

0 Answers  

What is difference between database and dbms?

0 Answers  

For more Database Management Interview Questions Click Here
Categories