Maximum number of indexes to one table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to link another table to a subtable, and every time I get the
error message that says I have too many indexes tied to my subtable and I
need to delete a link and then add another. Is there a maximum number of
links to a table where all the links are "reinforced referential integrity"?
is there another way around this problem?
 
The limit is 32, but that includes a hidden index for every relation wirh RI
that the table is involved in.

AFAIK, there is no way around this limit, other than to skip indexing some
less important fields, or create some of the less important relations
without Referential Integrity and ensure your code handles all the cases
that need handling.

Of course, this assumes you do have a normalized data structure, but IME it
is not uncommon to run into this limit even with a correctly designed
database. The most common one in my experience is a "client" table that
includes all sorts of entities (companies, individuals, shippers, suppliers,
....) and requires relations to many other tables.
 
Back
Top