Database Administrator Guide > Database Administrator Guide > Maintaining Storage Structures > Modify Procedures > Key Columns and Performance
Was this helpful?
Key Columns and Performance
For hash, ISAM, and B-tree structures, you must specify key columns. (Heap and heapsort tables do not have key columns.) There is no limit to the number of key columns that can be specified, but as key columns increase, performance declines slightly.
Last modified date: 01/30/2023