Robust plan query hint in SQL Server

The robust plan query hint force SQL Server to generate an execution plan that can run without failing due to potential data size overflow.it is useful for handling large value that might cause intermediate results to exceed expected size limits. It helps prevent runtime error especially with joins aggerates and large VARCHAR or Text column.

Syntex

Select * from tablename option (robust plan)

It forces SQL server to generate a more conservative execution plan that avoids runtime error due to large result set.