You are the administrator of SQL Server 2000 computer. The server contains a database name

d 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.

You examine the indexes in the PartsLocations table. The indexes are configured as shown in the Indexes exhibit.

You also examine the contiguity of the PK_partsLocations index and receive the following results:

DBCC SHOWCONTIG scanning 'PartsLocations' table...

Table: 'PartsLocations' (1); index ID: 1, database ID: 6

TABLE level scan performed.

- Pages Scanned................................: 3000

- Extents Scanned..............................: 750

- Extent Switches..............................: 502

- Avg. Pages per Extent........................: 4.0

- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]

- Logical Scan Fragmentation...................: 33.33%

- Extent Scan Fragmentation....................: 33.33%

- Avg. Bytes Free per Page.....................: 1166.0

- Avg. Page Density (full).....................: 85.77%

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.