April 2017
Beginner to intermediate
360 pages
9h 35m
English
One major limitation of secondary indexes is that they can only target one column. It would not be legal, for instance, to specify a secondary index such as follows:
CREATE INDEX ON "users" ("email", "encrypted_password");
We'll explore one workaround to this limitation in the Working with tuples section of Chapter 8, Collections, Tuples, and User-Defined Types.
Read now
Unlock full access