Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Robust Plan execution error?

Author  Topic 

lomvardi
Starting Member

7 Posts

Posted - 2003-05-24 : 10:46:10
I am running a select against a View that exceeds the max allowable row size and added OPTION (ROBUST PLAN) to the select to enable the select to return a result when the row size is a problem. The original view does a number of joins.

One of our users has reported that some data values they expect to see in some of the columns for specific rows are missing or incorrect. Could using the ROBUST PLAN hint cause this to occur?

Thanks,

Chris

JCamburn
Starting Member

31 Posts

Posted - 2003-05-25 : 19:12:20
Do you have a very long GROUP BY or ORDER BY clause?

Go to Top of Page
   

- Advertisement -