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

How do you pass values from one form to another form ?

1 Answers  

What are the main functions of a database management system?

0 Answers  

Can you copy the PROGRAM UNIT into an Object group ?

1 Answers  

What is database management system explain?

0 Answers  

What is the purpose of a model?

0 Answers  

What is the use of FILE option in EXP command ?

1 Answers  

What are functions in database?

0 Answers  

Enlist ways to efficiently code transactions.

0 Answers  

What are the characteristics of database management system?

0 Answers  

When should you consider denormalization?

0 Answers  

What is cluster table or non_cluster table?

1 Answers  

What do you understand by sub-queries in sql?

0 Answers  

For more Database Management Interview Questions Click Here
Categories