Enhancements to Existing Features › Select/Omit in DDL Index

Select/Omit in DDL Index

When you regenerate the existing database as a DDL database, the select/omit criteria gets generated into the DDL index as a WHERE clause. Any existing RLA function that uses the DDL database, can now access the same records that the RLA function has accessed over the DDS database.
Irrespective of the "Allow select/omit criteria" setting being static or dynamic, the select/omit criteria gets embedded in the DDL index. You do not have to regenerate and recompile the function. The select/omit criteria are generated for all the access path types that DDL supports.

Note: The select/omit criteria, over DDL implementation supports RTV and RSQ access paths.

The following documentation deliverables were updated for this feature:

• Building Access Paths