Media preference can be specified for an index or keyed file to request that the underlying index object be allocated on SSD storage. 媒介首选项可以针对索引或键控文件(KF)指定,请求将底层索引对象分配到SSD存储设备。
You can create a keyed logical file or an SQL index that shares the index of the physical file. 您可以创建一个键控逻辑文件或SQL索引,它们共享物理文件的索引。
In this case the row returned to RPG is dependent on which of the duplicate key handling DDS keywords ( LIFO ( default ), FIFO or LCFO ) were used when creating the keyed logical file. 在这种情况下,返回RPG的行取决于创建键逻辑文件时使用的是哪个用于处理DDS关键字的重复键(LIFO(默认值)、FIFO或LCFO)。
Assume that you have a DDS-created keyed physical file and only want the index on SSD and not the data. 假设您有一个DDS创建的键控物理文件,并且只希望在SSD中保存索引而不是数据。
It was not possible to specify different media preferences on different partitions ( members ) of a partitioned SQL index, not to mention a DDS-created keyed logical file with multiple members. 对于分区的SQL索引,无法对不同的分区(成员)指定不同的媒介首选项,更别说带有多个成员的DDS创建的键控逻辑文件。