You have a database server that has four quad-core 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)