ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 请教关于ANALYZE 命令的一些疑惑

请教关于ANALYZE 命令的一些疑惑

原创 Linux操作系统 作者:lfree 时间:2005-08-17 00:00:00 0 删除 编辑

摘自:http://www.itpub.net/410314.html

FOR TABLE Specify FOR TABLE to restrict the statistics collected to only table
statistics rather than table and column statistics.
FOR COLUMNS Specify FOR COLUMNS to restrict the statistics collected to only
column statistics for the specified columns and scalar object attributes, rather than
for all columns and attributes; attribute specifies the qualified column name of
an item in an object.
FOR ALL COLUMNS Specify FOR ALL COLUMNS to collect column statistics for all
columns and scalar object attributes.
FOR ALL INDEXED COLUMNS Specify FOR ALL INDEXED COLUMNS to collect
column statistics for all indexed columns in the table.
FOR ALL INDEXES Specify FOR ALL INDEXES if you want all indexes associated
with the table to be analyzed.



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-82793/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    2284
  • 访问量
    6023397