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?
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?