search

Home >Database >Mysql Tutorial >更新数据库中表的统计信息

更新数据库中表的统计信息

WBOY
WBOYOriginal
2016-06-07 14:56:351327browse

更新数据库中表的统计信息 无 IF EXISTS(SELECT name FROM sys.databases WHERE name=N'Test')BEGINUSE TestEXEC sp_updatestatsENDGO

更新数据库中表的统计信息 
IF EXISTS(SELECT name FROM sys.databases WHERE name=N'Test')
BEGIN
USE Test
EXEC sp_updatestats
END
GO
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：查找替换表中TEXT字段类型数据Next article：根据指定字符分割字符串并输出表格

Related articles

See more