正文

揭秘MSSQL数据库：性能优化与实战技巧对比分析

/0 浏览量
0822

在当今信息化时代，数据库作为存储和管理数据的核心技术，其性能直接影响着企业的运营效率。MSSQL（Microsoft SQL Server）作为一款广泛使用的数据库管理系统，拥有强大的功能和丰富的优化技巧。本文将深入探讨MSSQL数据库的性能优化与实战技巧，并通过对比分析，帮助读者更好地理解和应用这些技巧。

一、MSSQL数据库性能优化概述

1.1 索引优化

索引是数据库性能优化的关键因素之一。合理设计索引可以加快查询速度，降低数据检索成本。以下是一些常见的索引优化技巧：

  • 选择合适的索引类型：根据查询需求选择合适的索引类型，如哈希索引、B树索引等。
  • 避免过度索引：过多的索引会降低插入、删除和更新操作的性能，因此需要合理控制索引数量。
  • 使用复合索引：对于多列查询，可以使用复合索引来提高查询效率。

1.2 数据库分区

数据库分区可以将数据分散到多个物理文件中，提高数据访问速度。以下是一些数据库分区技巧：

  • 选择合适的分区键：分区键应具有较好的区分度，以便将数据均匀分布到各个分区。
  • 合理设置分区大小：分区大小应适中，过大或过小都会影响性能。
  • 定期维护分区：定期对分区进行维护，如合并分区、删除过期数据等。

1.3 缓存优化

缓存是提高数据库性能的重要手段。以下是一些缓存优化技巧：

  • 合理设置缓存大小：缓存大小应根据系统资源和工作负载进行调整。
  • 使用缓存策略：根据查询特点选择合适的缓存策略，如LRU（最近最少使用）策略。
  • 定期清理缓存：定期清理缓存，释放过期数据，提高缓存利用率。

二、MSSQL数据库实战技巧对比分析

2.1 索引优化实战

以下是一个使用MSSQL数据库进行索引优化的实战案例：

-- 创建索引
CREATE INDEX idx_user_name ON users (name);

-- 查询优化
SELECT * FROM users WHERE name = '张三';

在这个案例中，我们为users表中的name列创建了索引，从而提高了查询效率。

2.2 数据库分区实战

以下是一个使用MSSQL数据库进行分区的实战案例：

-- 创建分区函数
CREATE PARTITION FUNCTION pf_users_date (DATE) AS RANGE LEFT FOR VALUES ('2021-01-01', '2021-02-01', '2021-03-01');

-- 创建分区方案
CREATE PARTITION SCHEME ps_users_date AS PARTITION pf_users_date TO ([PRIMARY], [PRIMARY], [PRIMARY]);

-- 创建表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name NVARCHAR(50),
    birth_date DATE
) ON ps_users_date (birth_date);

在这个案例中，我们为users表创建了日期分区，将数据分散到不同的分区中，提高了数据访问速度。

2.3 缓存优化实战

以下是一个使用MSSQL数据库进行缓存优化的实战案例：

”`sql – 设置缓存大小 DBCC SET ARITHABORT ON; DBCC SET CURSOR_CLOSE_ON_COMMIT OFF; DBCC SET TRANCOUNT ON; DBCC SET TIMEOUT 3600; DBCC SET LOCK_TIMEOUT 3600; DBCC SET TEXTSIZE 2147483647; DBCC SET MAXANSIZE 2147483647; DBCC SET XACT_ABORT OFF; DBCC SET ARITHABORT ON; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET ANSI_WARNINGS OFF; DBCC SET ANSI_NULLS ON; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS_NULL ON; DBCC SET ANSI_NULL_DFLT_ON OFF; DBCC SET QUOTED_IDENTIFIER ON; DBCC SET ANSI_PADDING ON; DBCC SET ANSI_WARNINGS OFF; DBCC SET NUMERIC_ROUNDABORT OFF; DBCC SET CONCAT_NULL_YIELDS

-- 展开阅读全文 --