Jaison Joseph wrote:

>
>> How wide are records of trg_trg?
>
> CREATE TABLE TRG_TRG
> (
> TRG_ID Integer,
> TRG_EMP_ID Integer,
> TRG_DTTM Timestamp,
> TRG_CODE Integer,
> TRG_PRSD Smallint DEFAULT 0,
> TRG_TRD_ID Integer,
> TRG_DOR_CODE Varchar(16),
> TRG_DEV_ID Integer,
> CONSTRAINT PK_TRG_TRG PRIMARY KEY (TRG_ID)
> );

Hmmm. Not wide at all, I'd say.

Out of curiosity, how many record versions does this table have?

Regardless, you have to find a workaround on your side, I doubt any
server side optimization is possible in this case.


Dmitry