We are thinking of implementing the Identity solution for a table which can expect a volume of 75k applications created per day. This table has 5 children tables.
I have few questions on implementing the identity,
1. Is there any performance bottle neck of using the Identity for creating the Primary Key?
2. Does this Identity key will get inserted to the child tables automatically when I throw the insert command on the parent table?
3. Out of the 5 child tables 3 has other parent tables and different primary key. So if my question 2 is true, how does it happen in this scenario?.