4 ms·

The SQL world calls this an "index."

• etc-hosts 2y ago
  I am attempting to reach enlightenment by contemplating your wisdom.
• winrid 2y ago
  No. Most NoSQL dbs support indexes and secondary indexes too. In SQL world we call this "denormalization". It's called the same thing in NoSQL, too.
  • llm_trw 2y ago
    It's called materialized views.
    • winrid 2y ago
      Well, yes, and no. :)
  • dehrmann 2y ago
    Indices are essentially managed denormalization.
    • winrid 2y ago
      Ah, never thought of it that way.
• badpun 2y ago
  Indices are no good if you constantly do large amounts of inserts or updates (say, entire clickstream of a popular global site) - keeping them up to date will massively slow down the inserts/updates. Wheresas, in NoSQL, you can do as inserts as quickly as your disk can write data, and still query the dataset as if it had an index.
  • winrid 2y ago
    That has nothing to do with whether the DB is relational or not.
    • badpun 2y ago
      Which relational databases can simultaneously do milions of updates and milions of selects per second, to the same table?