How to use/enable Parsing Engine?

Database
Enthusiast

How to use/enable Parsing Engine?

Hi,

I want to optimize my query and would like to use optimizer. Please if anyone knows about how to enable Parsing engine/query optimizer, please help me.

I know about the usage of Parsing engine (PE) but i do not know how to enable this feature.

Thanks,
Uma Kathir
3 REPLIES
Enthusiast

Re: How to use/enable Parsing Engine?

PE is a built in virtual processor and we dont need to enable them, to execute/optimize the SQLs. cos, without PE, any SQL query cant get executed.

In order to optimize your SQL query, you could always, get the PE's plan of execution ( EXPLAIN ).

Then, we manually analyse the steps, like how the joins are performed,whether there is any accidental product joins, index cols are properly been gettin utilized, or something like that.

Alternatively, you could use the visual expalain, to get the flow chart kinda thing of the PE's plan.
Enthusiast

Re: How to use/enable Parsing Engine?

Hi Uma,
There are many method you can optimize ur query...If the collect stats was not there you can collect stats based on ur index columns ...U can change ur PDM according to your business...as Sarathy told u can view the expalin plan of ur query...in that u can view the spool space usage....the greater the usage of spool space....ur query performance will be down......the best way to optimize the query is choosing ur primary indexes and ppi...based on ur business that will improve ur query performance....
There is nothing u can do with parsing engine...since it has cost based optimizer ...it will generate more plans in executing ur query ....but it will choose the least cost for executing the query....hence we have to give the better input for the optimizer by collecting the stats and also by correctly choosing the PIs,USI's and PPI's
Enthusiast

Re: How to use/enable Parsing Engine?

Thanks, Sarathi & Gokul.