✏️ Explanatory Question

What are alternate keys, and why are they important?

👁 22 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Alternate keys enforce uniqueness using one or more columns. They:

  • Improve search performance

  • Enable upsert operations

  • Simplify integrations

  • Prevent duplicate records

They must be designed carefully to avoid breaking existing logic.