试题详情
- 多项选择题 You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50，000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal？（）
A、Place a nonclustered index on the date column.
B、Add a unique clustered index on the date column.
C、Map each partition to a filegroup， with each filegroup accessing a different physical drive.
D、Create a partitioning scheme that partitions the data by date.
- A,D
关注下方微信公众号，在线模考后查看
热门试题