DEV Community

Discussion on: How does database indexing of Arrays work?

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt • Edited

I think the answer is usually one-to-many relationships.

However, I am not sure if JSON or JSONB columns in PostGRES can be indexed. (That is, no Foreign keys needed.)