Hi @pickelrick26 -
Indexes do help in Charts, but only if your chart contains filters. If the filtered fields are indexed, MongoDB is way more efficient at finding the matching documents. If you are not using filters on your charts, indexes won’t help at all.
100K documents is likely more than a human is every going to look through. I suspect the best thing to do here would be to limit the number of documents returned. Right now there’s no Limit Results option on table charts (it’s coming soon), but you can do this yourself by entering a pipeline in the query bar with a $sort and $limit stage.
HTH
Tom