Changing this up to support the list index in general. The pull request was part of it (thanks!), but the resulting SQL currently leaves off the index condition. See https://gist.github.com/brmeyer/351b48d8d5731c1cfff5. The initial SQL is correct, but the AbstractLoadPlanBasedCollectionInitializer leaves the condition off. Taking a look.