Hi everybody,
now I have the following qery that still needs to much time:
select distinct Anschriften.ID as aid, Anschriften.PLZ as aplz,
Anschriften.STRASSE as astrasse, Anschriften.HNR as ahnr from Anschriften
inner join Master on Anschriften.ID=Master.A
inner join Master as m on
What database are you using?
Also, are all the fields involved in the joins and whare clause
properly indexed? Depending on the database you are using, it is possible
to determine if the indexed fields are being used.
-- bob
On Tue, 3 Jun 2003, André Sannerholt wrote:
Hi everybody,
now I