Query Hint (SQL Server Compact Edition)

  • Article

Affects all operators in the statement. You can indicate a query hint that should be used throughout an entire query. Query hints are specified as part of the OPTION clause.

Applies to

DELETE (SQL Server Compact Edition)

INSERT (SQL Server Compact Edition)

SELECT Statement (SQL Server Compact Edition)

UPDATE (SQL Server Compact Edition)

Remarks

Only one argument can be used when using a Query Hint with SQL Server 2005 Compact Edition:

  • FORCE ORDER
    Specifies that the join order indicated by the query syntax is preserved during query optimization.