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)