Clustered indexes on non-identity columns to speed up bulk inserts?

Well, I've put it to the test, and putting a clustered index on the two "chunk-defining" columns increases the performance of my table.

A clustered index is a physical index, a physical data structure, a row order. If you insert in the middle of the clustered index, the data will be physically inserted in the middle of the present data. I imagine a serious performance issue in this case.

I only know this from theory, because if I do this in practice, it will be a mistake according to my theoretical knowledge.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.