10 ms·
Anybody know if there any performance/query plan differences between the following? WHERE details->'attributes'->>'color' = 'neon yellow' And WHERE d
by zeroimpl 5y ago
Anybody know if there any performance/query plan differences between the following?
WHERE details->'attributes'->>'color' = 'neon yellow'
And
WHERE details['attributes']['color'] = '"neon yellow"'
- rcv 5y ago> While I wouldn't recommend simply using the subscript format everywhere in your application due to it not always leveraging indexes... I assumed that the subscript format was basically preprocessed into the arrow format, but this kind of implies that it's not. It's too bad the point isn't more clear here as I'm curious as well.