优化这个视图 create or replace view tracking_view_center_open as select ki.id recordNo, 'MTC入口' tollType, 'MTC' txType,--mtc get_station_name(ki.Station_Id) tollname, to_char(In_Date,'yyyy-MM-dd hh24:mi:ss') tollDate, ic_sn icCode, Lane_Id lane, to_number(In_Car_Sn_first_color) carRecognizeColor, In_Car_Sn_first carRecognize, '' as incarrecognize, ki.Car_Sn_first_camara carCode, Car_Type vType, User_Id tollid, 0 tollfree, 'n' as pay_type, '' as isFree, '' as para1, passid as passid, '' fee , '' payfee, '' currentdiscountfee, to_char(vehicleclass) enVehicleclass, in_car_sn_signid as vehiclepicid, cardtype,car_zs,'-1' as exitFeeType from etcportal.kw_lane_in_open ki UNION ALL select ko.id recordNo, 'MTC出口' catetype, 'MTC' txType,--mtc get_station_name(ko.station_id) exitName, Out_Date exitDate, ic_sn icCode, Lane_Id lane, to_number(car_sn_first_color) carRecognizeColor, car_sn_first carRecognize, in_car_sn_first as incarrecognizeColor, ko.Car_Sn_first_camara carExitcode, Car_Type vExit, User_id tollid, ko.R_Fee, ko.pay_type, para3 as isFree, para1, passid as passid, to_char(fee,'0.99') , to_char(payfee,'0.99') , to_char(currentdiscountfee,'0.99') , vehicleclass exitVehicleclass, vehiclesignid as vehiclepicid,cardtype,en_zs,to_char(exitFeeType) from etcportal.kw_lane_out_open ko;