There is always problem that when we create keys and on deletion of those keys we get jumps in the keys. like if i am having a database of 15 values with PK values from 1-15. Now suppose i have deleted a few rows, those keys will be deleted.
Now when ever i insert new row, i'll use new value onward from 15, we dont use those delelted values. That can create our db with sparce keys ... :-s ... what should i do, how to overcome it?
You should do nothing about it.
I assume this PK is actually an artificial PK and not a real one. Especially in that case you (or your application) should never rely on any "ordering" or implicit logic in the primary key. If you do, re-think your design.