>Thanks Sergey
>It took a long time to query a set of cursor from a huge table without index
>SQLExec(lnHandle, "select * from detail where type=m.type and ref_no=m.ref_no",'temp'")
>in order to speed up, how to create the index file and how to apply it ?
>

This link http://ronaldbradford.com/blog/tag/covering-index/ seems to be good explaining different types of indexes in MySQL