SELECT Child INDEX ON BINTOC(id_field)+CHR(selesManNum) TAG primTag && this is a candidate index for Child table or INDEX ON BINTOC(id_field)+CHR(selesManNum) TO sys(2023)+'\primTag' && this is best for temporary indexyou can rewrite this select with the best efficient code possible:
SELECT parent.id_field ; , parent.FirstName ; , parent.LastName ; , parent.Address ; , parent.city ; , parent.State ; , parent.zip ; , LOOKUP(child.FirstName,BINTOC(id_field)+CHR(1),child.id_field,"primTag")FirstName1 ; , LOOKUP(child.LastName,BINTOC(id_field)+CHR(1),child.id_field,"primTag") LastName1 ; , LOOKUP(child.FirstName,BINTOC(id_field)+CHR(2),child.id_field,"primTag")FirstName2 ; , LOOKUP(child.LastName,BINTOC(id_field)+CHR(2),child.id_field,"primTag")LastName2 ; ... , LOOKUP(child.FirstName,BINTOC(id_field)+CHR(20),child.id_field,"primTag") FirstName20 ; , LOOKUP(child.LastName,BINTOC(id_field)+CHR(20),child.id_field,"primTag") LastName20 ; FROM parentThis run into 1 or 2 ms