Strange perf.

Hi,

I have something weird with a query :
with 2 columns => 25 s
with * => less 1 s

how do you explain that ?

Thanks for your lights

select idper, idetot
 from vue_idetot_per
where idper in (select idperinf from prjexr) order by idetot

Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop

SELECT STATEMENT Optimizer Mode=CHOOSE 72 146   SORT ORDER BY 72 6 K 146
    HASH JOIN 72 6 K 132

      VIEW SYS.VW_NSO_1 84   1 K 59
        SORT UNIQUE  84   504   59
          TABLE ACCESS FULL ZA.PRJEXR 6 K 38 K 20
      NESTED LOOPS  30 K 2 M 72
        REMOTE  30 K 2 M 72   CBDSRV_SRVCNS.WORLD SERIAL
        REMOTE  8   48   1   CBDSRV_SRVCNS.WORLD SERIAL

select *
 from vue_idetot_per
where idper in (select idperinf from prjexr) order by idetot

Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop

SELECT STATEMENT Optimizer Mode=CHOOSE 72 148   SORT ORDER BY 72 8 K 148
    HASH JOIN 72 8 K 134

      VIEW SYS.VW_NSO_1 84   1 K 59
        SORT UNIQUE  84   504   59
          TABLE ACCESS FULL ZA.PRJEXR 6 K 38 K 20
      HASH JOIN  30 K 3 M 74
        REMOTE  8   64   1   CBDSRV_SRVCNS.WORLD SERIAL
        REMOTE  30 K 2 M 72   CBDSRV_SRVCNS.WORLD SERIAL