Query too slow
Hi,
i want to optimise a query that which take about 2 minutes to display results.
here is the code
Bonjour à tous,
je cherche à optimiser une requête qui prends plus de 87 secondes pour s'exécuter.
merci par avance pour vos idées et suggestion:
SELECT ID, Titre, Prix, Contact, Description,
(SELECT valeur from details where DT.ID = details.ID_Annonce and rubrique='Kilométrage') as Kilometrage,
(SELECT valeur from details where DT.ID = details.ID_Annonce and rubrique='Carburant') as Carburant,
(SELECT valeur from details where DT.ID = details.ID_Annonce and rubrique='Boîte de vitesse') as Boite_Vitesse,
(SELECT valeur from details where DT.ID = details.ID_Annonce and rubrique='Année-modèle') as Annee_modele,
Region, Ville, CodePostal
FROM annonces as DT
WHERE
DT.Categorie like '%voiture%'
AND (DT.`Export` = '0') AND (DT.`Contact` <> '') AND (char_length(DT.`Contact`) = 10)
Subject
Written By
Posted
Query too slow
August 26, 2012 07:30AM
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.