Hmm, fetching more than needed have unpleasant locking effects when updateable and/or scrollable cursors, more aggresive isolation levels and transaction control are used... Well, I suppose these Firehose cursors are only used in read-only situations like this, and they are probably more efficient on average... Then again, we are speaking about web aplications, where scrollable cursors, long transactions etc make no sense.

Thanks for clarification.

Dragi "Bonzi" Raos
Zagreb, Croatia
Q#5196, MkII#80000376, 18GB green