phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexey Karpov <>
Subject Secondary index question
Date Mon, 26 Feb 2018 11:45:05 GMT

Let’s say I have a table CREATE TABLE test (id integer NOT NULL PRIMARY KEY,
name VARCHAR, description VARCHAR)
with local index CREATE LOCAL INDEX ix_test_name ON test(name)

For the query SELECT * FROM test WHERE name = 'a'
it’s all right, Phoenix uses index.

But for the query SELECT * FROM test WHERE name = 'a' AND description = 'b'
It makes full scan over the table. Is there any way to make Phoenix use
index in such queries(when one field is in index and another is not),
without including another field into the index ?

I use HDP 2.6.2 and Phoenix 4.7.

Best regards,

Sent from:

View raw message