Hi @xtapodi Welcome to the community and Thanks for considering Elasticsearch.
Elasticsearch when configured correctly (hardware software and index strategy) is highly performant We would need to learn a little bit about what you're trying to do.
even 200 million records with the 100 attributes each is still a relatively small data set with respect to Elasticsearch.
I know you said no schema but there will be a schema whether you set it or not and then with proper queries you should be able to query across that entire data set with highly performant low latency queries.
I would suggest setting up the a node or a cluster or better yet just try a Elastic Cloud and do some testing.