Hi, Why do you think query is slow? What its execution time? What is expected time? How many nodes do you use? How much data does cache contains?
On Mon, May 8, 2017 at 1:47 AM, Guillermo Ortiz <[email protected]> wrote: > I have a simple cache where I have Person object (id, age and so on..) > > I have created indeces by id and age to try some examples but queries with > "group by" go really slow. > > I'm trying this query: > SELECT age > FROM > PersonWithindex > group by age > > > SELECT > AGE AS __C0 > FROM "personCacheWithIndex".PERSONWITHINDEX > /* "personCacheWithIndex"."age_idx" */ > GROUP BY AGE > /* group sorted */ > > SELECT > __C0 AS AGE > FROM PUBLIC.__T0 > /* "personCacheWithIndex"."merge_scan" */ > GROUP BY __C0 > > Although it seems that it uses index, why is it going so slow? I think > that it should be pretty fast with an index. > -- Best regards, Andrey V. Mashenkov
