Which option should you use?

You have a database server that has four quadcore
processors. This database server executes

complex queries that are used to generate reports.
You need to force a query to use only one processor core without affecting other queries.
Which option should you use?

You have a database server that has four quadcore
processors. This database server executes

complex queries that are used to generate reports.
You need to force a query to use only one processor core without affecting other queries.
Which option should you use?

A.
OPTION (FAST 1)

B.
OPTION (MAXDOP 1)

C.
OPTION (RECOMPILE)

D.
OPTION (MAXRECURSION 1)



Leave a Reply 0

Your email address will not be published. Required fields are marked *