How to best structure this data structure to avoid hitting index

Hi, I am working on setting my company’s course catalog index and here is the data I have so far: As you can see, the credits attr has quite a large amount of data as each course has credits attached and breaking down by profession state and each state can offer multiple credit types and each credit type can link to multiple credit categories. I currently hit the roadblock of index size too big since courses often times can have more than 50 profession credit states. I did try to follow th

Relative Strength Index (RSI) Indicator Explained With Formula

🧠 Data structures are the unsung heroes of computer science

Introduction To Hashing And Indexing - Studytonight

CBOE Volatility Index (VIX): What Does It Measure in Investing?

SQL index overview and strategy

Data Structures 8 What is Hashing?

Financial Modeling Best Practices: Tips & Tricks

Hashing in Data Structure

Implementation of Hash Table in Python using Separate Chaining

What is the best approach for solving data structures and algorithm problems? - Quora

Top five considerations for SQL Server index design