Explanation:
Index are created on the large table to speed up the data retrieval or if the changes are perfomed on the table and the column is used in the WHERE clause then on that column you should create an index to speed up the DML operations. If the table is small then index should not be created as this would slow the speed of queries execution.

---