Hi All, We have a region with 3 million records and we have put a index on the field which we are using for order by. From the <trace> we see that index is not being used, could you please let us know why index will not be used.
Following is the query "select distinct * from /UFCH order by read_datetime desc limit 10;" Range Index Created "create index --name=myIndex --region=/UFCH --expression=read_datetime" Index has no effect on the query execution time when used with order by. -- *Nikhil Chandrappa *| Data Engineer | New York (315) 396 - 3789 | [email protected] | Pivotal Software Inc. <http://www.pivotal.io/>
