I have two indexes:
city (id, name, fulltext_field)
street (id, city, name, fulltext_field)
Now i call
select * from city, street where ...
- Is there posibility to know which index belongs each found row?
- In result i see only id and name fields. As i understand result have only common fields for all indexes. But is there posibility to get non-common fields? I think they should contain NULL for other indexes. But if field is present in both indexes and have different type… Maybe alias to index should be used…
- If there are rows with same ID in both indexes - only one row will present in result. But i want to get rows from both indexes. Can i?
I tried to find answers in documentation - but found nothing. So if it is impossible now to do all this - can it be feature request?
Also i think to use multi-query instead of multi-index query. But as i understand queries from multi-query request will execute consistently. And multi-index query i can run in parallel - multi-core or multi-server if indexes are on different servers.