One to one relationship query
Just wondering on what people's thoughts are on this problem.
I currently have a table with about 70+ fields in it, and now I have hit the 32 index limit on the table.
So my two options are to:
a) create another table and have a one to one relationship with it. Pros: This will allow me to overcome the 32 index limit.
Cons: I will have to join these two tables together for any query and all existing queries and forms will need to be changed to reflect this new table
b) have the one table.
Pros: no changes to current application
Cons: unable to reinforce referential integrity on all the foreign key joins
Even though it seems like it's going to be a bit of extra work, I am favouring option a, but are there any other pro's and con's of either method?
Has anyone else come across a similar problem and what did they do?
What would you do?