下一个示例演示了如何不仅为表数据,还为索引和lob修改表空间。
The next example demonstrates how to alter the tablespace not only for table data, but also for indexes and LOBs.
目录中不会反映这些修改,除非在这些表和索引上执行RUNSTATS。
None of these changes are reflected in the catalog, unless RUNSTATS is performed on these tables and indexes.
在updatestatistics期间,数据修改小于所设置的STATCHANGE的表和索引将被直接跳过。
Tables and indexes with changes less than the imposed STATCHANGE are completely skipped during update statistics.
可以添加和删除索引;通过删除、改名或添加列来修改表;甚至在必要的时候借助于SQL。
You can add and drop indexes; alter tables by dropping, renaming, or adding columns; and even drop down into SQL as necessary.
根据完全计算数据立方和索引结构的特点,对基于基表的方案进行修改,演化出基于数据立方的一般型和层次预分组型两种优化方案。
According to the features of the completed computed cube and the index structure in the kernel system, two types of plans on the cube are put forward by modifying the plans on the base table.
从[资料表设计工具],您也可以在方格区按一下滑鼠右键,存取可用以建立和修改资料表关联性、条件约束、索引和索引键的对话方块。
From table Designer, you can also right-click in the grid section to access dialog boxes through which you can create and modify relationships, constraints, indexes, and keys for the table.
从[资料表设计工具],您也可以在方格区按一下滑鼠右键,存取可用以建立和修改资料表关联性、条件约束、索引和索引键的对话方块。
From table Designer, you can also right-click in the grid section to access dialog boxes through which you can create and modify relationships, constraints, indexes, and keys for the table.
应用推荐