Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

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…

Submitted by emma.c· Mar 30, 2026Identify considerations for relational data on Azure

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

How the community answered

(31 responses)

A
84% (26)
B
6% (2)
C
10% (3)

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

Topics

#T-SQL#index hints#query optimization#full table scan

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice