# B-tree index

Published articles for B-tree index.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Database Indexing: Types, Benefits & Best Practices

DevFeed: [Database Indexing: Types, Benefits & Best Practices](<https://devfeed.tech/articles/database-indexing-types-benefits-best-practices-105578.md>)

Original publisher: [Read original article](<https://talent500.com/blog/database-indexing/>)

Author: Ekakshar

Published: 2026-10-28T06:45:55Z

Content type: article

Language: en

Sources: [Talent500](<https://devfeed.tech/sources/backend-archives-talent500-blog.md>)

Topics: [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [Database](<https://devfeed.tech/topics/database.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [b-tree-index](<https://devfeed.tech/tags/b-tree-index.md>), [backend](<https://devfeed.tech/tags/backend.md>), [clustered-vs-non-clustered-index](<https://devfeed.tech/tags/clustered-vs-non-clustered-index.md>), [composite-index](<https://devfeed.tech/tags/composite-index.md>), [covering-index](<https://devfeed.tech/tags/covering-index.md>), [database](<https://devfeed.tech/tags/database.md>), [database-indexig](<https://devfeed.tech/tags/database-indexig.md>), [database-indexing](<https://devfeed.tech/tags/database-indexing.md>), [indexing](<https://devfeed.tech/tags/indexing.md>), [query-performance-optimization](<https://devfeed.tech/tags/query-performance-optimization.md>), [technology](<https://devfeed.tech/tags/technology.md>), [types](<https://devfeed.tech/tags/types.md>), [types-of-database-indexes](<https://devfeed.tech/tags/types-of-database-indexes.md>)

### AI overview

Indexes add data structures that can help databases find rows without scanning entire tables, and may also support filtering, joins, sorting, and uniqueness constraints. Their value depends on query patterns, data distribution, table size, and the optimizer: for queries returning many rows, a sequential scan may cost less. B-tree indexes support equality and range access; hash indexes suit equality lookups but generally not ranges. Composite index column order matters, and some engines support covering indexes to avoid fetching extra columns from table storage. Indexes use storage and add maintenance work to inserts, updates, and deletes. The text recommends basing indexes on actual queries, inspecting execution plans, and measuring results; behavior and capabilities vary by database engine.

### Source excerpt

Discover how Database Indexing improves query performance by enabling faster data retrieval without scanning entire tables. Explore index types, how indexing works, its benefits and trade-offs, and best practices for optimizing database queries and application performance. The post Database Indexing: Types, Benefits & Best Practices appeared first on Talent500 blog.

## OrioleDB Public Alpha

DevFeed: [OrioleDB Public Alpha](<https://devfeed.tech/articles/orioledb-public-alpha-475.md>)

Original publisher: [Read original article](<https://supabase.com/blog/orioledb-launch>)

Author: Pavel Borisov

Published: 2024-12-01T07:00:00Z

Content type: release

Language: en

Sources: [Supabase](<https://devfeed.tech/sources/supabase-blog.md>)

Topics: [Supabase](<https://devfeed.tech/topics/supabase.md>)

Tags: [alpha](<https://devfeed.tech/tags/alpha.md>), [b-tree-index](<https://devfeed.tech/tags/b-tree-index.md>), [drop-in](<https://devfeed.tech/tags/drop-in.md>), [extension](<https://devfeed.tech/tags/extension.md>), [feedback](<https://devfeed.tech/tags/feedback.md>), [free](<https://devfeed.tech/tags/free.md>), [getting-started](<https://devfeed.tech/tags/getting-started.md>), [gin](<https://devfeed.tech/tags/gin.md>), [heap](<https://devfeed.tech/tags/heap.md>), [hnsw](<https://devfeed.tech/tags/hnsw.md>), [index](<https://devfeed.tech/tags/index.md>), [pgvector](<https://devfeed.tech/tags/pgvector.md>), [platform](<https://devfeed.tech/tags/platform.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [production](<https://devfeed.tech/tags/production.md>), [public](<https://devfeed.tech/tags/public.md>), [standard](<https://devfeed.tech/tags/standard.md>), [storage](<https://devfeed.tech/tags/storage.md>), [storage-engine](<https://devfeed.tech/tags/storage-engine.md>), [supabase](<https://devfeed.tech/tags/supabase.md>)

### AI overview

OrioleDB Public Alpha is available on Supabase as a storage extension designed to replace Postgres' default Heap storage. It is intended to help testers provide feedback and is not suitable for production workloads. Alpha projects are limited to Free organizations and cannot be upgraded to larger instance sizes on the platform; supported indexes are limited to the default B-Tree, with GIN, GiST, BRIN, Hash, and pgvector's HNSW and IVFFlat unsupported. To try it, create a database at database.new and select "Postgres with OrioleDB" under Advanced Configuration. The source suggests using OrioleDB's official Getting Started guide for larger instances.

### Source excerpt

Launching OrioleDB Public Alpha