PRS

create index NM_UPPER_SURNAME_I on GRS_PERSON_NAMES

(upper(PRSN_SURNAME_TXT))



create index NM_UPPER_FIRSTNAME_I on GRS_PERSON_NAMES

(upper(PRSN_FIRST_GIVEN_NAME_TXT))



create index PID_UPPER_PROVIDERID_I on GRS_IDENTIFIERS

(upper(PROVIDER_CHID))