4 ms·
Not just being able to query them, but to be able to create useful indexes on the data at the same time still. This means you don't have to break out parts of
by simcop2387 8y ago
Not just being able to query them, but to be able to create useful indexes on the data at the same time still. This means you don't have to break out parts of the JSON into separate columns and maintain both a schema and a schemaless setup for them. The indexes aren't going to be as optimized as an index on a single column, but it makes the whole thing a lot more robust in the end than relying on your application or triggers to always keep mirrored columns up to date properly.
- deleted 8y ago[deleted]