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 database implementation?

0 Answers  

Explain the different types of database keys?

0 Answers  

What do you understand by database triggers?

0 Answers  

Explain what are the types of transparencies?

0 Answers  

What is the best way to determine whether firebird server is running?

0 Answers  

what is storage manager?

0 Answers  

What is data model example?

0 Answers  

Is it possible to break netlibs encryption?

0 Answers  

Explain what is meant by asymmetrical protocols?

0 Answers  

What are five types of database models?

0 Answers  

What are the features of dbms?

0 Answers  

what is the difference between inline query and corelated subquery

1 Answers  

For more Database Management Interview Questions Click Here
Categories