Bird
0
0

What is the default type of index created in PostgreSQL when you use CREATE INDEX without specifying the index type?

easy📝 Conceptual Q1 of 15
PostgreSQL - Indexing Strategies
What is the default type of index created in PostgreSQL when you use CREATE INDEX without specifying the index type?
ABRIN index
BHash index
CB-tree index
DGIN index
Step-by-Step Solution
Solution:
  1. Step 1: Understand PostgreSQL default index type

    PostgreSQL uses B-tree as the default index type for general purposes.
  2. Step 2: Confirm default behavior of CREATE INDEX

    When no index type is specified, PostgreSQL creates a B-tree index automatically.
  3. Final Answer:

    B-tree index -> Option C
  4. Quick Check:

    Default index type = B-tree index [OK]
Quick Trick: Default index in PostgreSQL is B-tree unless specified otherwise [OK]
Common Mistakes:
  • Assuming hash index is default
  • Confusing GIN or BRIN as default
  • Thinking no index is created without type

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes