Yes.
Runtime processing costs too. If a query can use multiple indices, then the query will be run with each index, essentially doing N times the work.
Yes.
Runtime processing costs too. If a query can use multiple indices, then the query will be run with each index, essentially doing N times the work.