MySQL Forums
Forum List  »  Italian

TEMPI LUNGHISSIMI DI RICERCA - AIUTO
Posted by: Lory Lory
Date: September 05, 2008 08:43AM

Incredibile.... faccio una left join con access identica a quella sotto e il risultato mi arriva in 2 secondi.
Eseguo la stessa query in mysql e i tempi sono di circa 2 minuti.... aiuto... non capisco il perchè.
es:
SELECT distinct Tabella1.* FROM Tabella1 LEFT JOIN Tabella2 ON Tabella1.ID = Tabella2.IDREL Where Tabella2.IDREL Is Null order by Tabella1.id

Options: ReplyQuote


Subject
Views
Written By
Posted
TEMPI LUNGHISSIMI DI RICERCA - AIUTO
3552
September 05, 2008 08:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.