A question on creating more than 500 fields In Transparent table

Hi,

I had an requirement for creation of more than 500 fields in a customized Z table. So kindly request the experts to suggest that is it suggestible to create these fields in 1 table by taking primary and secondary indexes when considered to be in performance.

Your answer is well appreciated.