User Tools

Site Tools


Sidebar

indexes:select-with-two-indexes

Q.I have a myspace space with two indexes:

1. primary: {type=hash,{parts=1,'num'}}.

2. secondary: {type='tree', unique=false, parts={2,'string'}}.

How can I do something like SELECT * FROM myspace WHERE field1 = condition1 and field2 > condition2 using both indexes? (2016)

A. There is no INDEX-MERGE operation in Tarantool, so create a third index for field1 and field2 and use it.

Comments

Enter your comment. Wiki syntax is allowed:
O E X O H
 
indexes/select-with-two-indexes.txt · Last modified: 2018/06/04 19:12 by eabates

Real Time Web Analytics