On Tue, Mar 1, 2011 at 4:44 AM, Joby Joba <jobyjoba59@gmail.com> wrote: > Me again ! I have checked this question of 'explain analyze' and I > understand now. > > When the problem occured I have run a 'EXPLAIN' > > I have run the request again to open this case using 'EXPLAIN ANALYZE' but I > didn't reproduce the case. That's why I sent the other trace but it doesn't > countain the information you are asking for. > So Tomas, you were right ! > > All apologies !!!!! (I'm confused) > > > But the problem still not resolved .....
What exactly is the problem? Is one version of this plan slow? Which one? If you can't reproduce with EXPLAIN ANALYZE (which actually runs the query), how are you reproducing this?
--- Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215 Foster City, CA 94404 (650) 242-3500 Main www.truviso.com