首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of SQL Server 2000 computer. The server contains a database named Inventory. The database has a set of
You are the administrator of SQL Server 2000 computer. The server contains a database named Inventory. The database has a set of
admin
2009-05-19
25
问题
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.
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.
答案
A
解析
Explanation:The output of the DBCC SHOWCONTIG shows that the clustered index of the table is fragmented. Both Logical Scan Fragmentation and Extent Scan Fragmentation are above 10%. The clustered index PK_PartsLocations should be rebuilt.
Note: In general, you need to do very little in terms of index maintenance. However, indexes can become fragmented. You can use the DBCC SHOWCONTIG command to report on the fragmentation of an index.
You can use either the Extent Scan Fragmentation value or the Logical Scan Fragmentation value to determine the general level of fragmentation in a table. Logical Scan Fragmentation and, to a lesser extent, Extent Scan Fragmentation values give the best indication of a table’s fragmentation level. Both these values should be as close to zero as possible (although a value from 0% through 10% may be acceptable).
Incorrect Answers:
B, C: There already exists a clustered index, the PK_PartsLocations index. A table can only contain one clustered index.
D: A clustered index is faster that a non-clustered index. We should rebuild the clustered index, not create a nonclustered index instead.
转载请注明原文地址:https://kaotiyun.com/show/muhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Itneverrainsbutitpours.Justasbossesandboardshadfinallysortedouttheirworstaccountingandcompliancetroubles,an
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Youliveinaroomincollegewhichyousharewithanotherstudent.Youfinditverydifficulttoworktherebecauseyourroomma
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
随机试题
案例分析题爱德华创造性的组织思想ABC公司是一家拥有30万名员工、116家分公司、年销售额高达480亿美元、业务遍布世界各地的跨国集团公司。这家公司经常性地将业务从一个国家转换到另一个国家,而它又试图使其
患者,男,28岁。行大腿深部弹片摘除术,为预防破伤风最常用的方法是注射
28岁,女性,月经量多1年,近10日经常鼻出血,脾肋下未及。血红蛋白90g/L,白细胞10×109/L,血小板30×109/L。骨髓检查:粒、红细胞系增生旺盛,巨核细胞增多,伴成熟障碍。应诊断为
社会因素作用的门户是
砂仁的药用部位是
血脂调节药的选用A、烟酸B、贝丁酸类C、鹅去氧胆酸D、胆酸螯合剂+贝丁酸类E、HMG-COA还原酶抑制剂治疗高胆固醇血症宜选用的药物是
下列()情况下,不得销毁会计档案。
上市公司的董事、监事、高级管理人员违背对公司的忠实义务,利用职务便利,操纵上市公司从事( ),致使上市公司利益遭受重大损失的,处3年以下有期徒刑或者拘役,并处或者单处罚金;致使上市公司利益遭受特别重大损失的,处3年以上7年以下有期徒刑,并处罚金
下列关于烟叶税的说法,正确的有()。
根据所给资料,回答下列问题。2015年4月,受理量高于2015年一季度平均水平的专利类型有几种?
最新回复
(
0
)