Re: [PERFORM] substring index what is better way to query

2017-06-20 Thread Tieson Molly
Lane" wrote: > Tieson Molly writes: > > I have an index I created on the prefix of a column: > > > create index location_geo_idx ON locations( substring(geohash, 0, 5)); > > > I currently use a similar to query, but I wanted to know if there is a > > faster w

[PERFORM] substring index what is better way to query

2017-06-20 Thread Tieson Molly
Good morning, I have an index I created on the prefix of a column: create index location_geo_idx ON locations( substring(geohash, 0, 5)); I currently use a similar to query, but I wanted to know if there is a faster way to query multiple value using this index than this? select l.geohash from l