不定项选择题

You are the administrator of SQL Server 2000 computer. The server contains a database named Inventory. The database has a set of tables that track the location of parts. The tables are configured as shown in the Database Schema exhibit.<br>You examine the indexes in the PartsLocations table. The indexes are configured as shown in the Indexes exhibit.<br>You also examine the contiguity of the PK_partsLocations index and receive the following results:<br>DBCC SHOWCONTIG scanning 'PartsLocations' table...<br>Table: 'PartsLocations' (1); index ID: 1, database ID: 6<br>TABLE level scan performed.<br>- Pages Scanned................................: 3000<br>- Extents Scanned..............................: 750<br>- Extent Switches..............................: 502<br>- Avg. Pages per Extent........................: 4.0<br>- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]<br>- Logical Scan Fragmentation...................: 33.33%<br>- Extent Scan Fragmentation....................: 33.33%<br>- Avg. Bytes Free per Page.....................: 1166.0<br>- Avg. Page Density (full).....................: 85.77%<br>You need to improve the performance of the queries that join this table to the Parts table and the Locations table. What should you do?

A. Re-create the PK_PartsLocations index as a clustered index.
B. Re-create the IX_PartsLocations_PartsID as a clustered index.
C. Re-create the IX_PartsLocations_LocationId as a clustered index.
D. Re-create the PK_PartsLocations index as a nonclustered index.

火星搜题