Creating index ~ mapping rdbms to index

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 .

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.