Never format the Database column like to_date,to_char etc since this will ignore the index usage.
Correct type:
Eg:SELECT DISTINCT ADD_WAYBILL FROM EX_CON_WAYBILL
WHERE CURDATE >= TO_DATE(:FROM_DATE,'DD-MM-YYYY')
AND CURDATE < truck_co =" 'GMS'">
Worng Type:
SELECT CURDATE, ADD_WAYBILL FROM TEST1
WHERE TO_DATE(CURDATE,'DD-MM-YYYY HH:MI:SS') >= TO_DATE(:FROM_DATE,'DD-MM-YYYY HH:MI:SS')
AND TO_DATE(CURDATE,'DD-MM-YYYY HH:MI:SS')<>
AND ADD_WAYBILL IS NOT NULL
AND TRIP_CODE IS NOT NULL
AND TRUCK_CO = 'GMS'
