Greetings, Please see the Query Below, is there any way I can make it efficent Oracle 9.0.1.2.0 on HP-UX I cannot use MV. This is for one hour. its there in every houlr report. CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash = Value --------------- ------------ -------------- ------ -------- --------- -----= ----- 142,450,789 204,722 695.8 23.7 1069.35 1439.02 16276= 65409 select TO_CHAR(min(DV),'YYYY-MM-DD HH24:MI:SS.FF') DV from ECL_T IRKS_DYNAMIC_PIAT having min(dv) is not null Regards & Thanks BN -- //www.freelists.org/webpage/oracle-l