>Is there a way to optimize this query?
>It takes about 6 seconds to select the records from a Table with 22000 records. I can't imagine what will happens if this table becomes bigger as I expect.
>
>

>SELECT DISTINCT Partida.Name AS Name, Results.Partida;
>       FROM Results;
>       LEFT JOIN Partida ON Results.Partida == Partida.Kod;
>       ORDER BY Results.Partida;
>INTO CURSOR cEl
>
>

SELECT Partida.Name AS Name, Results.Partida;
       FROM Results;
       LEFT JOIN Partida ON Results.Partida == Partida.Kod;
       GROUP BY 2,1;
INTO CURSOR cEl