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 ...
Get Getting Started with RethinkDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
