For which column would you create an indexSolutionAnswer Ind

For which column would you create an index?

Solution

Answer:

Indexes are created generally for many reasons like : to speed up the queries , it provides faster access to the data. Thus we create an index for the column which is been frequently used, when referential integrity constraints exists on the column or when unique key integirty constraint exists on the column.