Any one table is limited to 32. I'm not aware of any database-wide
limit.
[/QUOTE]
Where does that 32 come from?
I see that a table has a limit of 32 indexes. Howevew, when a table is on the
'1' side of a 1-M relationship, there isn't an index for THAT table is there...
it would be associated with the table on the 'M' side of the relationship. So
a table could be on the '1' side of 100 1-M relationships but could still only
have a single index. Or am I wrong? (I've been wrong a lot lately!)
Any one table is limited to 32. I'm not aware of any database-wide
limit.
[/QUOTE]
Where does that 32 come from?
I see that a table has a limit of 32 indexes. Howevew, when a table is on
the
'1' side of a 1-M relationship, there isn't an index for THAT table is
there...
it would be associated with the table on the 'M' side of the relationship.
So
a table could be on the '1' side of 100 1-M relationships but could still
only
have a single index. Or am I wrong? (I've been wrong a lot lately!)
Rick
[/QUOTE]
Whoops... backwards (I told you I was wrong a lot lately...)
But, still the same logic applies... if you switch my '1' and 'M' around.
It may be me that's wrong: there's nothing in the Specifications help
that would indicate a limit. OTOH, that would be a very peculiar "sea
urchin" relationship diagram; but you're right, I don't see anything
that would specifically exclude it!
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
