3 ms·
> First you start off with almost none, maybe a few on primary keys. Primary keys are always indexed. Does the author really know what he’s talking about?
by SoftTalker 4y ago
> First you start off with almost none, maybe a few on primary keys.
Primary keys are always indexed. Does the author really know what he’s talking about?
- Petersipoi 4y agoThe author clearly knows this based on the sentence you quoted. I’m very confused as to what your complaint is. > I have almost no fruit, just a few apples. Indicates that I do know that apples are a fruit. Not that I don’t.
- Petersipoi 4y agoGP edited their comment after I responded and didn’t mention it. Completely changed the comment. Was very antagonistic to the author of the article before.
- dewey 4y agoWhat about tables without primary keys?
- rzzzt 4y agoDBMS-s still have to identify a particular row somehow. That identifier is CTID in Postgres and ROWID in Oracle. Both will change if the data is moved around.
- deleted 4y ago[deleted]
- lgas 4y agoGenerally not a good idea to have these at all.
- wielebny 4y agoThese are usually stored in CSV files.
- eropple 4y agoA more generous interpretation would be the assumption that primary keys are (as they frequently are) synthetic data, and perhaps not the most commonly queried field aside from direct get-that-resource queries.
- deleted 4y ago[deleted]