A sequential scan is a database operation where each row in a table is read sequentially to find the required data, often resulting in slower performance for large datasets compared to indexed access. It is typically used when accessing a significant portion of a table or when no suitable index exists for the query conditions.