>We talked about that 2 weeks ago related to know if a subset is faster than a relational SQL.
>
>I presently have this.
>
>SELECT PRENOM,NOM FROM MEMBER WHERE EXISTS (SELECT NOMEMBER FROM LISTSERV WHERE NOCLIENT=5 AND LISTSERV.NOMEMBER=MEMBER.NUMERO)
>
>My MEMBER table is having 10000 recors and LISTSERV table about 100. I can't obtain an immediate result. It is taken a few seconds. How can I optimize this SQL?
Surely, it must be tested, but I would write:
SELECT PRENOM,NOM FROM MEMBER WHERE NUMERO IN (SELECT NOMEMBER FROM LISTSERV WHERE NOCLIENT=5)
Edward Pikman
Independent Consultant