首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of SQL server 2000 computer. The server contains a database named MedicalRecords. Users access medical
You are the administrator of SQL server 2000 computer. The server contains a database named MedicalRecords. Users access medical
admin
2009-05-19
55
问题
You are the administrator of SQL server 2000 computer. The server contains a database named MedicalRecords. Users access medical records by using the PatientID field. This field is the clustered primary key for the Patients table. When users try to access medical records, the database responds slowly. You examine the database options as shown in the exhibit.
You want to accelerate query response time and minimize administrative overhead. How should you reconfigure the database?
选项
A、Create a SQL Server Agent job to execute the UPDATE STATISTICS statement, and schedule the job to run weekly.
B、Select the Auto Update Statistics check box.
C、Run the database maintenance plan wizard, and accept the default settings.
D、Rebuild the primary key as a nonclustered primary key.
E、Clear the Auto Create Statistics check box.
答案
B
解析
Explanation: The Auto Update Statistics option is selected by default but in the Exhibit it has been disabled. Apparently the statistics are out-of-date and the queries are running slowly. The Auto Update Statistics option should be enabled to increase performance and minimize administrative overhead.
Note: SQL Server keeps statistics about the distribution of the key values in each index and uses these statistics to determine which index would be the best index to use for a particular query process. As the data in a column changes, index and column statistics can become out-of-date.
This can hinder the query optimizer’s ability to make optimal decisions on how to process a query. As a result query performance will deteriorate. When statistics become out-of-date they can be updated automatically if the Auto Update Statistics check box on the table property dialog box is checked.
Incorrect Answers:
A: It would require some administrative effort to set up job that update the statistics. Just selecting the Auto Update Statistics check is a better solution.
C: The Database Maintenance Plan Wizard cannot be used to recreate the statistics, which are the main problem at the moment.
Note: The Database Maintenance Plan Wizard can be used to set up the core maintenance tasks necessary to ensure that a database performs well, is regularly backed up, and is checked for inconsistencies. The Database Maintenance Plan Wizard creates a SQL Server 2000 job that performs these maintenance tasks automatically at scheduled intervals and can be used to reorganize the data on the data and index pages by rebuilding indexes with a new fill factor; compress data files by removing empty database pages; update index statistics to ensure the query optimizer has up-todate information about the distribution of data values in the tables; perform internal consistency checks of the data and data pages within the database to ensure that a system or software problem has not damaged data; backup the database and transaction log files; and to set up log shipping.
D: Looking at the exhibit we see that this is a statistics problem, not a index problem.
Note: A nonclustered index is similar to an index in a textbook. With this type of index, the data is stored in one place and the index in another. These indexes, however, point to the storage location of the data. Nonclustered indexes should be used on columns that contain a large number of distinct values; for queries that do not return large result sets; and for columns that are frequently involved in search conditions of a query that return exact matches. A clustered index, on the other hand, determines the physical order of data in a table. The PRIMARY KEY index automatically creates a clustered index as it is used to identify a row unless a nonclustered index is specified.
E: When set the Auto Create Statistics check box is checked, statistics are automatically created on columns that are used in a predicate. Adding statistics improves query performance because the SQL Server query optimizer can better determine how to evaluate a query. If the statistics are not used, SQL Server automatically deletes them. When this check box is cleared, statistics are not automatically created.
转载请注明原文地址:https://kaotiyun.com/show/suhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
SupposeyouphonedyourfriendMaryseveraltimesyesterdaybutshedidn’tansweryourcallatall.Writeheranemailto1
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
随机试题
下列维生素中,其衍生物参与形成丙酮酸脱氢酶复合体的是
自愿无偿献血是指下列哪种做法
下列能导致鼓胀发生的因素有()。
( )年,我国颁布了《中华人民共和国环境保护法(试行)》,明确了环境标准的制(修)订、审批和实施权限,使环境标准工作从此有了法律依据和保障。
背景:某土方支护工程,基坑挖土深度为一12m,基坑上口标高为0.5m,基坑长宽约为100m×50m,面积约为5000m2,地下承压水位在一15m以下,一8m深处有局部滞水。建设单位就该工程进行了招标,专业承包单位中标后,根据设计的基础图与地
上海证券交易所成立于()。
颜色的三个基本属性是()
下列属于操作技能的是()。
立国之初,明朝统治者就将发展教育事业放在重要地位,于是确立了“______”的文教政策。
毛泽东在1947年十二月会议上提出的新民主主义革命的三大经济纲领是
最新回复
(
0
)