[ASTERIXDB-2310] Use Primary Key Index to Enforce Insert Key Uniqueness

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Component/s: ING - Ingestion, STO - Storage
• Labels: triaged
• Assignee: Chen Luo
• Reporter: Chen Luo
• Created: 04/Mar/18 06:35
• Updated: 19/Sep/19 14:34
• Resolved: 19/Sep/19 14:34

Description

**Currently when ingesting data using INSERT operations, we always check the primary index to ensure key uniqueness. However, this implies in most cases all ingested records might be accessed, which will slow down the ingestion performance a lot when the records cannot be cached. To handle this, we can enforce key uniqueness by checking the primary key index, which is much smaller and can be more easily cached.