V_FMX_PD_DAY view -> add POI status to be in (0,3) and person status = 0

VehicleViewEx2 is a HUGE (extended) view... -> 4 STR tables are joined, only 1 is used to display a value

Order by clause is programatically set -> performance impact?

no such outcome in faces-config.xml -> "poiTraffic"

PoiHistoryView -> has Order by clause, could be moved to V_ADF_OC_POI_HISTORY ? + possible index on GPS_FULL_DATE and/or VEHICLE_DATA_ID (if they don't exist) in the same view ?
AND (vd1.remote_unit_id = ru.remote_unit_id OR Vehicle.remote_unit_id = ru.remote_unit_id) seems to be very heavy on performance /   vd1.remote_unit_id is only displayed?