[fpc-pascal] sqldb how to find a record fast with primary key

[Martin Schreiber]

On Friday 21 October 2011 17.41:56 Felipe Monteiro de Carvalho wrote:
> I get the value of the primary key of the table from the request, so I
> though that because it is the primary key I would be able to quickly
> jump to it. But it seams that not? From what I understood the
> solutions are first going through the entire table and indexing it to
> make future lookups faster. But this does not seam to use the fact
> that my field is the primary key.
> 
Can't you do the lookup in the DB server by a SQL join for example?

Martin