Which path has been selected by optimizer

manjinder · New User Joined: 04 Dec 2005 Posts: 45 Location: pune

i want to know which path has been selected by optimizer and list of the remaining paths please tell me the query.

thanx in advance.
regard..
manjinder

futuredba · New User Joined: 08 Jan 2006 Posts: 22 Location: Delhi

Hi manjinder,

While binding ur dbrm, one should specify explain = yes. After that, look out in ur plan_table, it will show u the path taken by optimizer.

we can tell some other paths that optimiser can choose(obviously, only if we modify the query) but i dont know whether one can get some list which will show all the paths that can be taken by optimizer.

regards,
futuredba

saranya_sn · New User Joined: 03 Jul 2005 Posts: 12 Location: India

Can some one tell me for the pakage how to look for the optimiser path

ragshere · New User Joined: 20 Dec 2004 Posts: 70

Hi,
you can get the accesspath chosen by optimizer for a query through PLAN_TABLE.
But all the possible paths will not be saved anywhere.
possible paths will be calculated by optimizer internally during BIND and select most optimum path and saves it.

Thanks
Rags