Home » RDBMS Server » Enterprise Manager » [Newbie]Using EM to tune execution plan for a query (10.2.0.4)
[Newbie]Using EM to tune execution plan for a query [message #439500] Sun, 17 January 2010 22:51
summoner
Messages: 44
Registered: March 2009
Member
Hi all,

In the past, we created tuning sets to select historical query for tuning.

However, we now need to test a query and tune it before deploying it. I test the execution plan and the result show that the plan use hash joining instead of using bitmap index. So I would like to check the recommend execution plan in EM console in browser to see whether i could change the plan.

Could anyone help me to see how to run the query in EM? I could only find historical query in the console.
Also, if bitmap index is not suggested by the oracle system, is it possible that I can compare the difference of performance between using hash join and bitmap indexing?

Thanks help
Previous Topic: how to install 10g oem db console on windows?
Next Topic: how to install Java based EM for 10g R2 ?
Goto Forum:
  


Current Time: Thu Mar 28 08:27:39 CDT 2024