多选题
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？（）
发布日期：2021-03-17
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.
标签： "暂无标签"
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在