UDA.CONVERT_TIMESTAMP_LITERAL_TO_DATE_LITERAL

This entry is specific to Oracle only. When the boolean value is set to true, then UDA converts the TIMESTAMP literal with 0 time value to a DATE literal. Oracle uses index scan on a DATE column.

Because the Oracle DATE column contains the date and time parts, UDA reports the Oracle DATE datatype as TIMESTAMP.

Cognos Analytics treats the Oracle DATE column as a TIMESTAMP, and generates a TIMESTAMP literal in the filter.

When you compare the DATE column and the TIMESTAMP literal, then the Oracle optimization adds an internal function on the DATE column to make the comparison compatible. This impacts the performance of Oracle.

Syntax

UDA.CONVERT_TIMESTAMP_LITERAL_TO_DATE_LITERAL= "database_name: boolean_value"

Data type

Boolean

Default

False