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

What Needs to be Considered When Indexing in Your Database

Hash Table Data Structure - Studytonight

Indexing Essentials in SQL

Indexing Essentials in SQL

8 Common Data Structures every Programmer must know

SQL indexing best practices How to make your database FASTER

Page table - Wikipedia

Indexing Essentials in SQL

8 Common Data Structures every Programmer must know

Hi y'all! Is this size too big to wear everyday? T

Flange Size Chart

SHOOLEX Shoe Filler for Too Big Shoes Men/Women Toe Cushion Insert

How To Style Our New Baggy Fits In A Big Way (Literally)

VivoFoot 4 PCs Anti-slip Heel Grips, Thick Liners & Fillers for Half-Size Too Big or Loose Shoes, Heel Cushion inserts, Heel Pads to Prevent Heel Slipping Out, Rubbing and Blisters (Beige)