You have too many attributes best option will be not use covered index. CREATE index ix1 on bucket(attribute8);