I have a SQL2000 view that is my source for a CRXI report.
Unfortunately -- I have one record where the query has a rowlength of 8,901 characters -- far surpassing the "limit" of 8,060...
CR errors on this record and suggests using a "ROBUST PLAN" hint in the query.
1. Can I use this option in a view?
2. What is the proper syntax/placement?
I have tried researching and just messing around with it -- no luck yet.
I'd prefer not to have to break this query into two pieces (and am willing to take a performance hit to avoid it) -- but that is my third option -- segmenting the record out and running it separately will be option #2.
Thanks.
Dave
Unfortunately -- I have one record where the query has a rowlength of 8,901 characters -- far surpassing the "limit" of 8,060...
CR errors on this record and suggests using a "ROBUST PLAN" hint in the query.
1. Can I use this option in a view?
2. What is the proper syntax/placement?
I have tried researching and just messing around with it -- no luck yet.
I'd prefer not to have to break this query into two pieces (and am willing to take a performance hit to avoid it) -- but that is my third option -- segmenting the record out and running it separately will be option #2.
Thanks.
Dave
