Customized Remote Work Solutions From the World’s Largest Fully Remote CompanyCustomized Remote Work SolutionsLearn More

Indexing

Showing 1-3 of 3 results
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 2

by Mirko Marović

Sorting a table can make some queries faster—but the maintenance cost is untenable. Enter real database indexes and their most common implementation structure: the B-tree.

10 minute readContinue Reading
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 1

by Mirko Marović

Properly used, an SQL database index can be so effective that it might seem like magic. But the following series of exercises will show that underneath, the logic of most SQL indexes---and wielding them correctly---is quite straightforward.

8 minute readContinue Reading
EngineeringIcon ChevronBack-end

Full Text Search of Dialogues with Apache Lucene: A Tutorial

by Doug Sparling

Apache Lucene is a powerful Java library used for implementing full-text search on a corpus of text. With its wide array of configuration options and customizability, it is possible to tune Apache Lucene specifically to the corpus at hand - improving both search quality and query capability. This article gives us a glimpse of the simplicity and ease of customization of the Apache Lucene analysis pipeline.

15 minute readContinue Reading

Join the Toptal® community.