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

Here is the result of SYS(3054,11) function:

Rushmore optimization level for table results: none
Rushmore optimization level for table partida: none
Joining table results and table partida using index tag Partidakod

SET DELETED is OFF

I try to create Unique index on Partida but the result was the same.