For storing the nostr events to return yes. But not necessarily for searching unless sticking to the limited filters from NIP-01
Discussion
Partitioning by field values/ranges, and other stuff like POW score, hashtags referenced, key phrases referenced are better suited for dedicated indexers imho