Hi ,

AS PER ORIGINAL QUERY
=====================

OPERATION OPTIONS OBJECT_NAME COST
-------------------- ------------------------- -------------------- ----------
SELECT STATEMENT 3024
FILTER
TABLE ACCESS FULL PS_JRNL_HEADER 3024
INLIST ITERATOR
INDEX RANGE SCAN PSHJRNL_HEADER 2
NESTED LOOPS 3
NESTED LOOPS 2
TABLE ACCESS FULL PS_LED_GRP_TBL 1
TABLE ACCESS BY INDEX ROWID PS_LED_TMPLT_TBL 1
INDEX UNIQUE SCAN PS_LED_TMPLT_TBL
INDEX UNIQUE SCAN PSASET_CNTRL_REC 1

11 rows selected.

The Query rewrite as UNION cost even though involved is high it executes in 2 seconds.What my Question is How to include the OR cluase also along with UNION Operator as work around.

Regds

Sambath