2 ms·
You should make your cursors opaque so as to never reveal the size of your database. You can do some other cool stuff if they're opaque - encode additional sta
by echelon 1y ago
You should make your cursors opaque so as to never reveal the size of your database.
You can do some other cool stuff if they're opaque - encode additional state within the cursor itself: search parameters, warm cache / routing topology, etc.
- rockwotj 1y agoCame here to say these same things exactly. Best write up I know on this subject: https://use-the-index-luke.com/sql/partial-results/fetch-next-page https://use-the-index-luke.com/sql/partial-results/fetch-nex...