Hi,
You can have clustered and non-clustered indexes, columnar and non-columnar indexes. What you need, based on the queries fetch data , volume of data, structure of data , data growth rate and ....
I have 17 years experience in data engineering , data warehouse designing and database developing. I have just started my activity in freelancer and regardless of the budget of the project I want to do this task and your review at the end will be my main profit.