DP-900 · Question #143
DP-900 Question #143: Real Exam Question with Answer & Explanation
The correct answer is A: SELECT. Table hints override the default behavior of the Query Optimizer for the duration of the data manipulation language (DML) statement by specifying a locking method, one or more indexes, a query-processing operation such as a table scan or index seek, or other options. Table hints
Question
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
Options
- ASELECT
- BWHERE
- CJOIN
Explanation
Table hints override the default behavior of the Query Optimizer for the duration of the data manipulation language (DML) statement by specifying a locking method, one or more indexes, a query-processing operation such as a table scan or index seek, or other options. Table hints are specified in the FROM clause of the DML statement and affect only the table or view referenced This applies to the following commands: https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table
Community Discussion
No community discussion yet for this question.