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

How to fix an Array Index Out Of Bounds Exception in Java

Separate Chaining Collision Handling Technique in Hashing - GeeksforGeeks

Double Top: Definition, Patterns, and Use in Trading

Best Practices for Database Indexing Strategies

Boyer Moore Algorithm for Pattern Searching - GeeksforGeeks

Financial Modeling Best Practices: Tips & Tricks

The Ultimate Guide to Consistent Hashing

How to use Inspect Element in Chrome, Safari, and Firefox

Highly accurate protein structure prediction with AlphaFold

Python Data Structures: Lists, Dictionaries, Sets, Tuples (2023)

Principal® on X: Explore the latest economic news in a minute or less: #InsightsInAMinute / X

SQL Developer – A great tool and better ways to use it - Simple Talk

Linear probing - Wikipedia

How to Index Data for Efficient Querying: Tips and Tricks

4 Index Data Structures A Data Engineer Must Know – Fly Spaceships With Your Mind