In simple terms, fragment-level statistics allows storage of column data distributions per fragment, and building the table level from its constituent fragments.
简单来说,片段级统计允许按片段存储列数据分布,并从组成的片段中构建表级别。
After completing Step 1, by default all the subunits in the subunits list table will be converted to fragments.
在完成步骤1之后,默认条件下子单元列表中的所有子单元都会转化为片段。
If the table has fragment-level statistics, the decision to refresh statistics is done at the fragment level, thereby rebuilding statistics only for changed or new fragments.
如果表具有片段级统计,那么将在片段的层面上判断是否执行统计刷新,因此只有片段被修改或出现新片段的情况下重建统计。
Note that the XML document fragment in Table 1 matches all three schema fragments in Table 1, Listing 9, and Listing 10.
要注意,表1中的XML文档片段与表1、清单9和清单10中三个模式片段都匹配。
Specifying a table name results in all fragments of that table being defragmented.
指定一个表名导致该表中的所有片段被整理。
The DBA does not have to create all the possible fragments for a table up front.
DBA 无需为当前表格创建所有可能的片段。
Notice that data from all fragments is sorted together to form table level statistics, which is encoded and stored in the system catalog sysdistrib.
注意,来自所有片段的数据被一同存储,形成了表级别的统计数据,被编码并存储到系统目录sysdistrib中。
Storing multiple table or index fragments in a single dbspace.
在单个dbspace中存储多个表或索引片段。
Finally table level statistics is formed by merging all constituent fragments statistics and stored in sysdistrib.
最终,将所有这些片段统计合并起来就构成了表级统计数据,并存储到sysdistrib。
Storing multiple table or index fragments in a single dbspace improves query performance over storing each fragmented expression in a different dbspace.
与在单个dbspace中保存多个表或索引片段提高了查询性能,这样做胜过将每个分段表达式存储在不同的dbspace中。
Before attaching fragments place the table in alter mode.
附加片段之前,要先将表置于alter模式之下。
You can store multiple fragments of the same table or index in a single dbspace, reducing the total number of dbspaces needed for a fragmented table.
在单个dbspace中可以存储同一个表或索引的多个片段,从而减少分段表所需要的dbspace总体数量。
The command in Listing 4 creates a table called tab_list that fragments data based on column state using list fragmentation.
清单4中的命令使用清单存储残片根据列状态创建了一个名为tab_list的表格。
The command in Listing 5 creates a table called tab_interval that fragments data on column id using interval fragmentation.
清单5中的命令创建了一个名为tab_interval的表格,它使用区间存储残片分隔列id上的数据。
The following table gives the size of minibin for each datatype with a combination of resolution and number of fragments.
下表给出了每种数据类型的迷你箱状图的大小,同时还给出了解析率和片段数。
The table has three initial fragments: p0, p1, and p2.
表格有三个初期片段:p 0, p1和p2。
Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.
那么得先找出这个表有哪些索引,哪些索引是位图索引,怎么查呢?
Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.
那么得先找出这个表有哪些索引,哪些索引是位图索引,怎么查呢?
应用推荐