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

Scaling Through Chaos

Worst cases for various data structures - Stack Overflow

SQL indexing best practices How to make your database FASTER

Is Protein BLAST a thing of the past?

Understanding HashMap Data Structure With Examples

Relative Strength Index (RSI) Indicator Explained With Formula

How to Index Data for Efficient Querying: Tips and Tricks

Indexing — Data Structures, by Sandali Tharuki, Nerd For Tech

Indexing Essentials in SQL

Mapped: The State of Global Democracy in 2022

Hashing in Data Structure

How to best structure this data structure to avoid hitting index size too big issue - Open Q&A - Algolia Community

Data Structures 8 What is Hashing?

A Deep dive into Data Structures(DS), by Eren Mollaoğlu