Interview Questions for Business Analysts and Systems Analysts


Recent Interview Questions | Search | Subscribe (RSS)

?
INTERVIEW QUESTION:

What is a Database Index?

Posted by Chris Adams

Article Rating // 15166 Views // 0 Additional Answers & Comments

Categories: Systems Analysis, Data Analysis & Modeling

ANSWER

A database index is a data structure that is created to provide a fast and efficient means of finding data rows in tables.  You can picture this the same way an index of a book helps you find specific material quickly. 

In a relational database, an index is a copy of one part of a table. Indices can be created using one or more columns of a database table.  However, a simplified visualization of an index would be to picture it as a separate table with one column containing a key value and a second column containing a pointer to (or the location of) the row within a table containing the same key value. The index entries are maintained in key sequence.  This provides for faster querying using various types of search technique that deliver non-linear response times. Some databases also allow indices to be created only for records that satisfy some conditional expression.

Some fields are automatically indexed by the DBMS.  Primary keys and fields marked as ‘unique’ fall into this category.  This is done to aid in the efficiency and quick enforcement of constraints.  If a field such as social security number or email address is marked as ‘unique’ then the database will create and use the index to ensure that data is not introduced which conflicts with this constraint.

There are drawbacks to database indices as well.  Database indices take up storage space.  They also make for slower data insert, updates, and deletes since both the data within the tables and the indices need to be updated.

print this answer

RATE THIS TOPIC

ADDITIONAL ANSWERS / COMMENTS

Only registered users may post comments.

Do your homework prior to the business analysis interview!

Having an idea of the type of questions you might be asked during a business analyst interview will not only give you confidence but it will also help you to formulate your thoughts and to be better prepared to answer the interview questions you might get during the interview for a business analyst position.  Of course, just memorizing a list of business analyst interview questions will not make you a great business analyst but it might just help you get that next job.





Select ModernAnalyst Content

Register | Login

Copyright 2006-2019 by Modern Analyst Media LLC