他使用的是varchar,不是char,所以,最坏的情况是你说三页。
另外,聚集索引是一张表中最宝贵的资源,如果检索的是聚集索引列,数据读取的效率显然最高,怎么可能降低存取效率。
我觉得lz的这个现象还是得根据实际情况分析一下表空间的占用情况。附一个表空间查看语句(非原创):
USE [要查询空间信息的库名]
GO
SELECT
ServerName = CONVERT(sysname, SERVERPROPERTY('ServerName')),
DatabaseID = DB_ID(),
DatabaseName = DB_NAME(),
ObjectID = DATA.id,
Owner = USER_NAME(DATA.uid),
ObjectName = DATA.Name,
Reserved = CONVERT(decimal(15, 2), DATA.Reserved / SPER.PageSperMB),
DataSize = CONVERT(decimal(15, 2), (DATA.DataSize + DATA.[TextSize]) / SPER.PageSperMB),
IndexSize = CONVERT(decimal(15, 2), (DATA.IndexSize - DATA.DataSize - DATA.[TextSize]) / SPER.PageSperMB),
UnUsedSize = CONVERT(decimal(15, 2), (DATA.Reserved - DATA.IndexSize) / SPER.PageSperMB),
DATA.Rows
FROM(
SELECT
O.id, O.uid, O.name, O.xtype,
Reserved = ISNULL(SUM(CASE WHEN IX.indid IN (0, 1, 255) THEN CONVERT(dec(15), IX.reserved) ELSE 0 END), 0),
DataSize = ISNULL(SUM(CASE WHEN IX.indid < 2 THEN CONVERT(dec(15), IX.dpages) ELSE 0 END), 0),
[TextSize] = ISNULL(SUM(CASE WHEN IX.indid = 255 THEN CONVERT(dec(15), IX.used) ELSE 0 END), 0),
IndexSize = ISNULL(SUM(CASE WHEN IX.indid IN (0, 1, 255) THEN CONVERT(dec(15), IX.used) ELSE 0 END), 0),
Rows = ISNULL(MAX(CASE WHEN IX.indid < 2 THEN IX.rows ELSE 0 END), 0)
FROM dbo.sysindexes IX WITH(NOLOCK)
INNER JOIN dbo.sysobjects O WITH(NOLOCK)
ON IX.id = O.id
WHERE O.xtype IN ( 'U')--, 'S')
AND O.status > =0
AND (IX.indid < 2 OR IX.indid = 255)
GROUP BY O.id, O.uid, O.name, O.xtype
)DATA
CROSS JOIN(
SELECT PageSperMB = 1048576. / low, low
FROM master.dbo.spt_values
WHERE number = 1
AND type = 'E'
)SPER
ORDER BY ObjectName, Owner
GO
追问话说我只有一张表。另外2个数据库有很多表,之前倒是查看过占用空间情况。软件开发人员说是软件存储的问题,导致异常增大,只是我没明白,无论软件怎么存储,数据插入到库到表应该都差不多吧,为什么就出现这种问题了。