OleDbSchemaGuid.Table_Statistics 字段

定义

描述提供程序中表的可用统计集合。Describes the available set of statistics on tables in the provider.

public: static initonly Guid Table_Statistics;
public static readonly Guid Table_Statistics;
 staticval mutable Table_Statistics : Guid
Public Shared ReadOnly Table_Statistics As Guid 

字段值

Guid

注解

Table_Statistics 映射到 OLE DB TABLE_STATISTICS 行集。Table_Statistics maps to the OLE DB TABLE_STATISTICS rowset. 除非另外指定,否则将按以下顺序返回限制列。Unless otherwise specified, restriction columns are returned in the following order.

限制列Restriction column CLR 数据类型CLR data type 说明Description
TABLE_CATALOGTABLE_CATALOG string 此统计信息的表的目录名称。Catalog name of the table of this statistic. 如果提供程序不支持目录,则为 null 值。A null value if the provider does not support catalogs.
TABLE_SCHEMATABLE_SCHEMA string 表的架构名称。Schema name of the table. 如果提供程序不支持架构,则为 null 值。A null value if the provider does not support schemas.
TABLE_NAMETABLE_NAME string 表名。Table name.
STATISTICS_CATALOGSTATISTICS_CATALOG string 统计信息的目录名称。Catalog name of the statistic. 如果提供程序不支持目录,则为 null 值。A null value if the provider does not support catalogs.
STATISTICS_SCHEMASTATISTICS_SCHEMA string 统计信息的架构名称。Schema name of the statistic. 如果提供程序不支持架构,则为 null 值。A null value if the provider does not support schemas.
STATISTICS_NAMESTATISTICS_NAME string 统计信息的名称。Name of the statistic.
STATISTICS_TYPESTATISTICS_TYPE UInt16 (Int32) 指定此统计支持的统计信息类型的位掩码:Bitmask specifying the kinds of statistics supported by this statistic:

DBSTAT_HISTOGRAM-表示直方图支持。DBSTAT_HISTOGRAM - Indicates histogram support.

DBSTAT_COLUMN_CARDINALITY-指示列基数支持。DBSTAT_COLUMN_CARDINALITY - Indicates column cardinality support.

DBSTAT_TUPLE_CARDINALITY-表示元组基数支持。DBSTAT_TUPLE_CARDINALITY - Indicates tuple cardinality support.

Note: 直方图只对应于多列统计信息的第一列。Note: Histograms correspond to only the first column for a multi-column statistic.

适用于