Re: [PERFORM] Query Analyser

2007-07-11 Thread Michael Fuhr
On Tue, Jul 10, 2007 at 08:17:05PM +0530, Gauri Kanekar wrote: Is there anyway so as to indicate the Query Analyser not to use the plan which it is using regularly, and use a new plan ? You can't dictate the query plan but you can influence the planner's decisions with various configuration

[PERFORM] Query Analyser

2007-07-10 Thread Gauri Kanekar
Hi List, Is there anyway so as to indicate the Query Analyser not to use the plan which it is using regularly, and use a new plan ? From where do the Query Analyser gets the all info to prepare a plan? Is it only from the pg_statistics table or are there anyother tables which have this info.