You work in an International company named TAKEEEN. And you’re in charge of the database of your company. You intend to use SQL Server 2008 to create a database solution. There’re two stored procedures in the database. The stored procedures are respectively named AlterSelling and GetSelling. Every day the two procedures are executed very often. The AlterSelling stored procedure updates a table named SellingOrders by using a transaction. From the SellingOrders table, data is retrieved and aggregated by the GetSelling stored procedure for a sales trend analysis report. When users run the sales trend analysis report, they have to wait for a long time.
So what should you do to make sure that sales trend analysis report runs as quickly as possible?
A. For AlterSelling, the isolation level should be changed to SERIALIZABLE
B. The NOLOCK hint has to be added to the SELECT statements in GetSelling
C. The NOWAIT hint has to be added to the SELECT statement in GetSelling
D. For AlterSelling, the isolation level should be changed to READ UNCOMITTED
