Wednesday, March 28, 2012

Robust Plan execution error?

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,

ChrisRefer to this link (http://www.sql-server-performance.com/hints_query.asp) for tips on ROBUST PLAN and SQLMAG (http://www.sqlmag.com/forums/messageview.cfm?catid=9&threadid=15767) link for references.

No comments:

Post a Comment