Comment optimiser ma requête?
Bonjour,
je rencontre actuellement un temps de reponse trop long sur mon appli web, et lorsque j'execute cette même requete directement en base, le temps de reponse est trop malgré une recherche restreinte à 1 enregistrement.
Pourriez vous me dire ce que je pourrai faire pour optimiser ma requete ci-dessous et m'explique aussi le plan d'execution.
merci
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
SELECT ext__0__0.RefTe1, ext__1.Pu_CodeSURF, ext.SolCrDt, ext__1.Pu_ID, ext.SolPu_ID_,
ext.SolCreID, ext__3__0.RefTe1, ext__3__1.EntID, ext__0.ActID, ext__3.PerID,
ext__3__1.EntCorpName, ext.SolID, ext__3.PerName, ext__0.ActName, ext__0.ActFstName,
ext__5.RefTe1, ext.SolPerId, ext__3.PerFstName, ext__3.PerEntId, ext__6.RefTe1
FROM Solicitation ext
LEFT OUTER JOIN Actor ext__0 on ext.SolCreID = ext__0.ActID
LEFT OUTER JOIN RefValues ext__0__0 on (ext__0.ActCivID = ext__0__0.RefID)
LEFT OUTER JOIN Purchase_ ext__1 on ext.SolPu_ID_ = ext__1.Pu_ID
LEFT OUTER JOIN Person ext__3 on ext.SolPerId = ext__3.PerID
LEFT OUTER JOIN RefValues ext__3__0 on (ext__3.PerCivID = ext__3__0.RefID)
LEFT OUTER JOIN Enterprise ext__3__1 on ext__3.PerEntId = ext__3__1.EntID
LEFT OUTER JOIN RefValues ext__5 on (ext.SolCanalID_ = ext__5.RefID)
LEFT OUTER JOIN RefValues ext__6 on (ext.SolMotiveID_ = ext__6.RefID)
LEFT OUTER JOIN Actor ext__8 on ext.SolActID = ext__8.ActID
LEFT OUTER JOIN RefValues ext__9 on (ext.SolPtyID = ext__9.RefID)
LEFT OUTER JOIN RefValues ext__10 on (ext.SolCatID = ext__10.RefID)
WHERE
( (UPPER(ext__3.PerName) LIKE UPPER(N'chaunu%') and UPPER(ext__3.PerFstName)
LIKE UPPER(N'enzo%')) or (UPPER(ext__3.PerName) LIKE UPPER(N'chaunu%')
and UPPER(ext__3.PerFstName) LIKE UPPER(N'% enzo%')) or
(UPPER(ext__3.PerName) LIKE UPPER(N'% chaunu%') and UPPER(ext__3.PerFstName)
LIKE UPPER(N'enzo%')) or (UPPER(ext__3.PerName) LIKE UPPER(N'% chaunu%')
and UPPER(ext__3.PerFstName) LIKE UPPER(N'% enzo%')))
ORDER BY ext.SolNextUpd ASC,ext__8.ActCode ASC,ext__9.RefTe1 ASC,ext__10.RefTe1 ASC |
