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 sql in database management system?

0 Answers  

Explain the terms specialization and generalization.

0 Answers  

What is db driver?

0 Answers  

How do I check my drivers?

0 Answers  

Define RDBMS.

0 Answers   Ernst Young, Thomson Reuters,

What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?

0 Answers  

Explain what are the types of transparencies?

0 Answers  

What is a logical backup ?

3 Answers   Wipro,

List few restrictions that are imposed while creating views?

0 Answers  

What is the purpose of a model?

0 Answers  

What is service based database?

0 Answers  

Can we attach the same List of Values to different fields in Design time ?

1 Answers  

For more Database Management Interview Questions Click Here
Categories