Last-Modified Column Index Name
The collection metadata component that specifies the name of the index on the last-modified column.
The value of this component is the name of a nonunique index on the last-modified time-stamp column. The index is created if a name is specified. This index can improve the performance of read and write operations that are driven by last-modified time stamps.
Only SODA for REST provides such an operation (operation GET collection with time-stamp parameters since and until). Other implementations do not use this component, since they do not provide any read or write operations that are driven by last-modified time stamps. Even for SODA for REST, it is typically better not to set this component if you are sure that your application does not use any read or write operations that are driven by time stamps, because creating and maintaining an index carries a cost.
| Property | Value |
|---|---|
| Default value | None |
| Allowed values | Valid Oracle quoted identifier1 (as defined in Oracle Database SQL Language Reference). If this value contains double quotation marks (") or control characters, SODA replaces them with underscore characters (_). |
| JSON collection metadata document path | lastModifiedColumn.index |
See Also: Oracle REST Data Services SODA for REST Developer’s Guide
-
Reminder: letter case is significant for a quoted SQL identifier; it is interpreted case-sensitively. ↩