| [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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
