{"action":"created","issue":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809/labels{/name}","comments_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809/comments","events_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809/events","html_url":"https://github.com/rethinkdb/rethinkdb/issues/809","id":14335226,"number":809,"title":"Support efficient index intersection","user":{"login":"coffeemug","id":48436,"avatar_url":"https://avatars.githubusercontent.com/u/48436?v=3","gravatar_id":"","url":"https://api.github.com/users/coffeemug","html_url":"https://github.com/coffeemug","followers_url":"https://api.github.com/users/coffeemug/followers","following_url":"https://api.github.com/users/coffeemug/following{/other_user}","gists_url":"https://api.github.com/users/coffeemug/gists{/gist_id}","starred_url":"https://api.github.com/users/coffeemug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coffeemug/subscriptions","organizations_url":"https://api.github.com/users/coffeemug/orgs","repos_url":"https://api.github.com/users/coffeemug/repos","events_url":"https://api.github.com/users/coffeemug/events{/privacy}","received_events_url":"https://api.github.com/users/coffeemug/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/labels/cp:reql","name":"cp:reql","color":"02d7e1"},{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/labels/tp:enhancement","name":"tp:enhancement","color":"02e10c"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/41","html_url":"https://github.com/rethinkdb/rethinkdb/milestones/subsequent","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/41/labels","id":367201,"number":41,"title":"subsequent","description":"","creator":{"login":"coffeemug","id":48436,"avatar_url":"https://avatars.githubusercontent.com/u/48436?v=3","gravatar_id":"","url":"https://api.github.com/users/coffeemug","html_url":"https://github.com/coffeemug","followers_url":"https://api.github.com/users/coffeemug/followers","following_url":"https://api.github.com/users/coffeemug/following{/other_user}","gists_url":"https://api.github.com/users/coffeemug/gists{/gist_id}","starred_url":"https://api.github.com/users/coffeemug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coffeemug/subscriptions","organizations_url":"https://api.github.com/users/coffeemug/orgs","repos_url":"https://api.github.com/users/coffeemug/repos","events_url":"https://api.github.com/users/coffeemug/events{/privacy}","received_events_url":"https://api.github.com/users/coffeemug/received_events","type":"User","site_admin":false},"open_issues":329,"closed_issues":0,"state":"open","created_at":"2013-06-30T07:32:52Z","updated_at":"2015-05-21T21:14:28Z","due_on":null,"closed_at":null},"comments":18,"created_at":"2013-05-14T22:35:39Z","updated_at":"2015-05-26T19:46:54Z","closed_at":null,"body":"```\r\ntable('foo')\r\n .between(i, j, index='a')\r\n .between(k, l, index='b')\r\n .between(m, n, index='c')\r\n```\r\n\r\nCurrently we can only use a single index at a time. We should eventually support efficient index intersection (which is a neat problem). This is obviously in backlog because:\r\n\r\n* There's far more important low-hanging fruit\r\n* None of the state of the art systems in this space support this\r\n* A lot of technical (language optimizer) work likely needs to be in place before we can do this"},"comment":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/comments/105645459","html_url":"https://github.com/rethinkdb/rethinkdb/issues/809#issuecomment-105645459","issue_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/809","id":105645459,"user":{"login":"primitive-type","id":1878644,"avatar_url":"https://avatars.githubusercontent.com/u/1878644?v=3","gravatar_id":"","url":"https://api.github.com/users/primitive-type","html_url":"https://github.com/primitive-type","followers_url":"https://api.github.com/users/primitive-type/followers","following_url":"https://api.github.com/users/primitive-type/following{/other_user}","gists_url":"https://api.github.com/users/primitive-type/gists{/gist_id}","starred_url":"https://api.github.com/users/primitive-type/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/primitive-type/subscriptions","organizations_url":"https://api.github.com/users/primitive-type/orgs","repos_url":"https://api.github.com/users/primitive-type/repos","events_url":"https://api.github.com/users/primitive-type/events{/privacy}","received_events_url":"https://api.github.com/users/primitive-type/received_events","type":"User","site_admin":false},"created_at":"2015-05-26T19:46:54Z","updated_at":"2015-05-26T19:46:54Z","body":"Has there been any progress on this issue for RetinkDB 2.0? "}}