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 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 Master.FN=m.FN > inner join Personen on m.NN=Personen.ID > where Personen.ID = "$id" > > It gives me the correct results > I hope you can help me to get it faster! > > André > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
