lua box.space.space_name:create_index('index_name', {type = 'tree', parts = {{field = field_name, type = 'string'}}}) lua box.select(space_name, { join = 'inner', on = { { space_name, 'field_name_1', '=', join_space_name, 'field_name_2' }, }, where = { { space_name, 'field_name_3', '>', 10 }, }, group_by = { join_space_name, 'field_name_2' }, order_by = { join_space_name, 'field_name_2' }, limit = 100, }) lua local plan = box.space.space_name.index.index_name:select({ query_conditions }, { iterator = 'EQ' }):explain()