The following sections in this document contain information about designing tables optimally using indexes. Indexes and Maps Primary Index, Primary AMP Index, and NoPI Objects Secondary Indexes Join and Hash Indexes