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 Get Google to Index Your Website

Database Indexing Strategies - ByteByteGo Newsletter

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

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

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

Open Addressing Collision Handling technique in Hashing

How to Optimize Indexing for Text and Numeric Data

System Design — 8 Data Structures That Power Your Databases, by Mahesh Saini

Quantitative Data: What It Is, Types & Examples

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

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

SQL indexing best practices How to make your database FASTER

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

Understanding HashMap Data Structure With Examples