arceemolano

CREATE INDEX idx_rptdetail_taxtrans ON RPTASSESSMENTDETAIL(TAXTRANS_ID, CLASSCODE_CT);
CREATE INDEX idx_rptassessment_prop ON RPTASSESSMENT(PROP_ID, APPROVEDBY);
CREATE INDEX idx_property_prop_id ON PROPERTY(PROP_ID, MUNICIPAL_ID, PROPERTYKIND_CT, BARANGAY_CT);
CREATE INDEX idx_propertyowner_prop ON PROPERTYOWNER(PROP_ID, LOCAL_TIN);
CREATE INDEX idx_taxpayer_localtin ON TAXPAYER(LOCAL_TIN);