On Fri, 9 Jul 2004, Bill Chandler wrote:

> Thanks to all who have responded.  I now think my
> problem is not related to deleting/recreating indexes.
> Somehow it is related to JDBC cursors.  It appears
> that what is happening is that since I'm using 
> a fetch size of 5000, the command:
> 
> FETCH FORWARD 5000 FROM JDBC_CURS_1
> 

If the top level node of your execution plan is a sort step, it should 
take essentially no time to retrieve additional rows after the first 
fetch.  The sort step is materializes the results so that future fetches 
simply need to spit this data back to the client.

I would agree with Dave's suggestion to use log_duration and compare the 
values for the first and subsequent fetches.

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to