Sql is running very slow
Sql statement-----------
SELECT emplid, empl_rcd, dur, TO_CHAR (dur, 'YYYY-MM-DD'), punch_type,
TO_CHAR (CAST ((punch_dttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
TO_CHAR (CAST ((punch_end) AS TIMESTAMP), 'YYYY-MM-DD-HH24.MI.SS.FF'),
rule_element_1, rule_element_2, rule_element_3, rule_element_4,
rule_element_5, taskgroup, oprid, reported_status, oprid_last_updt,
TO_CHAR (CAST ((dttm_modified) AS TIMESTAMP),Sql Statement
'YYYY-MM-DD-HH24.MI.SS.FF'
),
TO_CHAR (CAST ((dttm_created) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'
),
trc, tl_quantity, country, business_unit, LOCATION, deptid, jobcode,
business_unit_pc, project_id, activity_id, resource_type,
resource_category, resource_sub_cat, user_field_1, user_field_2,
SELECT emplid, empl_rcd, dur, TO_CHAR (dur, 'YYYY-MM-DD'), punch_type,
TO_CHAR (CAST ((punch_dttm) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'),
TO_CHAR (CAST ((punch_end) AS TIMESTAMP), 'YYYY-MM-DD-HH24.MI.SS.FF'),
rule_element_1, rule_element_2, rule_element_3, rule_element_4,
rule_element_5, taskgroup, oprid, reported_status, oprid_last_updt,
TO_CHAR (CAST ((dttm_modified) AS TIMESTAMP),Sql Statement
'YYYY-MM-DD-HH24.MI.SS.FF'
),
TO_CHAR (CAST ((dttm_created) AS TIMESTAMP),
'YYYY-MM-DD-HH24.MI.SS.FF'
),
trc, tl_quantity, country, business_unit, LOCATION, deptid, jobcode,
business_unit_pc, project_id, activity_id, resource_type,
resource_category, resource_sub_cat, user_field_1, user_field_2,
0