salut a tous, j'ai une requête qui me pose un grand problème, son temps d'exécution et très grand merci de m'indiquer comment je peut l'optimiser.
voici la requête:
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13 SELECT a.ID as a_ID," & _ "a.LogicalParentPath as a_LogicalParentPath," & _ "a.RefLanguage as a_RefLanguage," & _ "a.Priority as a_Priority," & _ "a.Title as a_Title," & _ "a.TreeDepth as a_TreeDepth," & _ "a.RefParent as a_RefParent," & _ "a.Active as a_Active," & _ "a.IsPrivate as a_IsPrivate," & _ "a.IsFrontPrivate as a_IsFrontPrivate," & _ "at.Label as at_Label " & _ "FROM article a, articletemplate at WHERE a.RefTemplate=at.ID and a.ID = " & ToSQL(par_ID , "Number")
Partager