Thank you all for your responses.

We decided not to re-order the ids on table update.

I mean once a data is deleted no re-assigning occurs and when a new data is...

I just want to clarify my question - I am intersted to know if it is possible to create partitons on the fly.

I am facing an issue in which I...

I only gave the book scenario as an example, in my real problem I will have some thing like million records per one entity.

So, is there a way of creating...