A non-clustered index in a database is a data structure that improves the speed of data retrieval operations on a table at the cost of additional writes and storage space. Unlike a clustered index, it maintains a separate structure from the data rows, allowing multiple non-clustered indexes per table to optimize different query patterns.