I would improve my query next by AWR
hello performance's guru
I would like improve my query next :
1 - I executed the statment next :
select * from table (dbms_xplan.display_awr('&1'));
2 - my result is >>>>> the cost is 165K
Question : - I would like find an other plan d'execution by sql_profile or by an advisor ?
best regards
JP
SQL_ID gv73azmda8dtx
--------------------
SELECT DISTINCT LID.NUMERO_ARTICLE,LID.REVISION_ARTICLE,LID.ITERATION_AR
TICLE,LID.VERSION_ARTICLE,AM.ETAT,AM.ORGANISATION,AM.CONTEXTE,LID.VUE_NA
TIVE_ARTICLE,LID.NOM_ARTICLE,LID.DATE_PUBLICATION,AM.DATE_PUBLICATION
FROM V_LIENARTICLEDOCUMENT_PURCHASE LID,V_ARTICLE_PURCHASE AM WHERE
I would like improve my query next :
1 - I executed the statment next :
select * from table (dbms_xplan.display_awr('&1'));
2 - my result is >>>>> the cost is 165K
Question : - I would like find an other plan d'execution by sql_profile or by an advisor ?
best regards
JP
SQL_ID gv73azmda8dtx
--------------------
SELECT DISTINCT LID.NUMERO_ARTICLE,LID.REVISION_ARTICLE,LID.ITERATION_AR
TICLE,LID.VERSION_ARTICLE,AM.ETAT,AM.ORGANISATION,AM.CONTEXTE,LID.VUE_NA
TIVE_ARTICLE,LID.NOM_ARTICLE,LID.DATE_PUBLICATION,AM.DATE_PUBLICATION
FROM V_LIENARTICLEDOCUMENT_PURCHASE LID,V_ARTICLE_PURCHASE AM WHERE
0