Indexing Strategies: B-Tree Quiz Home › PostgreSQL DBA › Indexing Strategies: B-Tree 🗂️ Postgres Database Administration – Indexing Strategies: B-Tree 20 questions · 15 min timer · Explanations included · Free 1. In a scenario where you need to index a large table with a timestamp column that is queried for ranges, which index type would be most efficient? B-Tree GIN GiST BRIN None 1 out of 20 2. When should you consider using a BRIN index over a B-Tree index? When the table is small and frequently updated When the table is large and queries involve range scans When the table has high cardinality columns When the table requires full-text search capabilities None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's upTime is Up!