O'Reilly logo

Getting Started with RethinkDB by Gianluca Tiepolo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating and using an index

As you have learned, the previous query requires a table scan; that is, RethinkDB had to look through the name field in every document. Indexes are a great way to fix queries such as this because they organize data by a given field to let RethinkDB find it quickly.

Our test query uses the name field, so we will now create a simple index on that field.

The quickest way to create an index in RethinkDB is using the web interface.

First, select the people table from the Tables tab, and then click on the Create a new secondary index link. Enter the name of the field on which you wish to create the index. In our example, this is the name field:

When you click on Create, RethinkDB will begin creating the desired index. Depending ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required