24 Jan
2011
24 Jan
'11
10:25 a.m.
Hi, Lichao! On Jan 24, Lichao Xie wrote:
Hi, Sergei! I'm sorry, my English is not so good! There is no a API to get the exact records in a range, but the API can help to improve performance for the case: select count(*) from t where id > 10 and id < 1000000; I want to know why there is no such a API.
Because we did not need it so far - no engine had it. And because the set of queries that it can optimize is pretty small, so it most cases this feature is not worth implementing. Regards, Sergei