This topic has not yet been rated - Rate this topic

Hints (SQL Server Compact Edition)

SQL Server 2005

SQL Server 2008 R2
SQL Server 2008

Options or strategies specified for enforcement by the Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) query processor on SELECT, INSERT, UPDATE, or DELETE statements.

Using Hints

The hints override any execution plan the query optimizer might select for a query.

Note:
Because the query optimizer of SQL Server typically selects the best execution plan for a query, we recommend that <join_hint>, <query_hint>, <table_hint>, and <view_hint> only be used as a last resort by experienced developers and database administrators.

The following hints are described in this section:

Table Hint (SQL Server Compact Edition)
Query Hint (SQL Server Compact Edition)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD