In databases, how do you determine whether making an index on one particular column is good, useless, or bad?

543 views

In databases, how do you determine whether making an index on one particular column is good, useless, or bad?

In: Technology

4 Answers

Anonymous 0 Comments

The easiest way is to run whatever query your doing a few times without an index and a few times with an index and see if it makes a difference to the average speed.

You are viewing 1 out of 4 answers, click here to view all answers.