Set Optimize for Unknown hint

This is applicable for objects using only the table implementation type.

  1. On the Designers tab, expand the tree view to locate the object.
  2. Right-click the source object and select Detailed Properties > Processing Options (ETL) > Overview.
  3. Click the Add SQL Option button. The SQL Option form is displayed.
  4. Select the Add OPTIMIZE FOR check box.
  5. Select the Unknown option.
  6. Click Apply then OK.
  7. Run the object compilation.