3 ms·
I don't. Well, to be honest, for a long time I had just assumed that the database "took care" of that kind of stuff. In reality, the people who managed the dat
by crispyambulance 4y ago
I don't.
Well, to be honest, for a long time I had just assumed that the database "took care" of that kind of stuff. In reality, the people who managed the database had indexed columns for us, and/or provided guard-rails for developer folks in the form of stored procedures. For a long time I never worried about indexes because I didn't have to. I still have not even the slightest idea what "a cursor" is.
It's only when you _actually_ have to do it yourself that you learn, sometimes harshly, the nature of databases.
- dominotw 4y agoThere are things like ottertune that do this.
- ofrzeta 4y agoDoes it work? Seems it's a now a commercial enterprise that has sprung from a CMU DB group project. An old version's still on Github: https://github.com/cmu-db/ottertune https://github.com/cmu-db/ottertune They also had Peloton, a "self-driving SQL database management system", that's a dead project now.
- dkjaudyeqooe 4y agoA cursor lets you step through a table one row at a time. You can use it to move between rows and read and update them.