-- ABS-10712

CREATE INDEX XIE1UNIQUERESIDENTIALITEM ON UNIQUERESIDENTIALITEM (PRIMARYID ASC);
CREATE INDEX XIE2UNIQUERESIDENTIALITEM ON UNIQUERESIDENTIALITEM (SUBSTR(PRIMARYID,-4) ASC);
CREATE INDEX XIE3UNIQUERESIDENTIALITEM ON UNIQUERESIDENTIALITEM (SUBSTR(PRIMARYID,-5) ASC);