A reasonable structure of table index could accelerate data search speed.
合理构造表索引将有效提高数据库查询速度。
If table index shafts are loose, tighten mounting bolts.
如果台面索引轴松动,拧紧固定螺栓。
To get the best performance out of your queries it is often necessary to tailor the table index definitions.
为得到最好的查询性能,通常你需要调整表的索引定义。
then DB2 could use the four-column index the "traditional" way (index, table, index, table, etc.) to return the rows in the desired order (the same order as or the reverse order of the index).
然后,DB2可以以 “传统”方法(索引、表、索引、表,等等)使用这个 “4列” 索引以期望的次序(与索引相同或相反的顺序)返回所需行。
Table index. Last addressed line of a standard table or sorted table. Is set to 0 if hashed table is accessed.
表索引。标准表或者排序表的最后被定位的行(表循环中当前所在行)。如果访问哈希表,则设置为0。
Table index. Last addressed line of a standard table or sorted table. Is set to 0 if hashed table is accessed.
表索引。标准表或者排序表的最后被定位的行(表循环中当前所在行)。如果访问哈希表,则设置为0。
应用推荐