Glossary

Performance impact:

The split itself requires multiple I/O operations (read original CI, write both CIs, update index). - After the split, records that were in key sequence within one CI are now spread across two CIs. Sequential reads that previously required one I/O now require two. - Repeated splits create a fragment

Learn More

Related Terms