Primary key on splited table

R

Roy Goldhammer

Hello there

I have a table with data that return on itself with diffrent value:
agreement with 5 breakes

When i build it i splitted it for two tables: one with the agreement and its
own id

and second table with: own id(primary key), the id from the agreement table,
breaks and rate.

the id on the second table was made before to declare the relationships so
that the relation will be one to many.

Now i'm thinking mayby i should remove the BreakID field and make the id
from the agreement table and the break field (both of them is a unique data)
the primary key

Will it bring to better preformance?
 

Ask a Question

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.

Ask a Question

Top