🎴 Flashcard Mode

When a cursor is used without setting a fetch size (batch size), each fetch operation typically retrieves one row at a time, requiring a separate network roundtrip to the database server. This is inefficient for large result sets. Modern database APIs allow setting a fetch size to retrieve multiple rows per roundtrip, but the default behavior described in the statement is accurate.