A cross join is a database operation that returns the Cartesian product of two tables, combining each row of the first table with every row of the second table. It is useful for generating all possible combinations of data sets but can result in large datasets if not used carefully.