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

QuestionsCategory: DP-900Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
Admin Staff asked 4 months ago
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

A. SELECT

B. WHERE

C. JOIN










 

Suggested Answer: A

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 in that clause.
This applies to the following commands:
DELETE -
INSERT -
SELECT -
UPDATE -
MERGE -
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table

This question is in DP-900 Microsoft Azure Data Fundamentals Exam
For getting Microsoft Certified: Azure Data Fundamentals Certificate



Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.