Question

Explain CI Split and CA Split.

Answer 1

CI and CA split occur when new data records are inserted. When a record is to be inserted in a CI and there is not enough space to fit it, the CI will be split.

• CI SPLIT: Essentially, it refers to the movement/transfer of some records from an existing CI to a free CI within the same CA when an addition or update is not feasible in the existing CI.
• CA SPLIT: It refers to the movement/transfer of half of the records from one CA to another one when an addition or update is not feasible in the existing CI.  This results in two CAs that are around half full rather than one full and one empty.