FoundationDB

9.

Indexing and Query Patterns

9.1.

Index Design Principles

9.1.1.

Index Key Structure

9.1.2.

Index Maintenance

9.1.3.

Query Performance

9.1.4.

Storage Overhead

9.2.

Secondary Index Implementation

9.2.1.

Index Creation Patterns

9.2.2.

Index Update Strategies

9.2.3.

Consistency Maintenance

9.2.4.

9.3.

Composite Indexes

9.3.1.

Multi-Column Indexes

9.3.2.

Index Key Ordering

9.3.3.

Partial Indexes

9.3.4.

Covering Indexes

9.4.

Range Query Optimization

9.4.1.

Key Prefix Matching

9.4.2.

Range Scan Patterns

9.4.3.

Pagination Strategies

9.4.4.

Performance Tuning

9.5.

Full-Text Search Patterns

9.5.1.

Text Indexing Strategies

9.5.2.

Search Implementation

9.5.3.

Ranking and Scoring

9.5.4.

Performance Considerations

9.6.

Aggregation Patterns

9.6.1.

Count Operations

9.6.2.

Sum and Average

9.6.3.

9.6.4.

Group By Operations

Previous

8. Transaction System Deep Dive

Go to top

Next

10. Operational Management