For creating pointers to the data, indexed are used. They help in finding rows in a table quickly. Indexes can be defined for multiple columns together with a different name. They cannot be seen or accessed by users but helps in improving the database performance. For small tables, impacts can be negligible. In the case of complex data tables, the impact of indices is clearly visible.