An index scan is a database operation that involves searching an index to find the relevant rows in a table, which can be more efficient than scanning the entire table when only a subset of data is needed. It is particularly useful when the query involves conditions on indexed columns, allowing for faster data retrieval by leveraging the index structure.