We have an existing sql data from where we kind of planning to get only aggregated entity which is bounded by key constraints which is mapped to index .
Now my query , is it good to have one sql table or entity per index or table with constraints being aggregated as index .
but going with aggregated data would have complex mapping built but it does reduce the number of indexes being created in future .
And creating single entity per index , would mean relative search with one key found being targeted from other index to get aggregate result which may not be the right way to go according to me .
Kindly let me know on this which would be the better approach .