I have two sites with the same table.
Both have the same indexes on that table.
I want to Query - using an index. On both the tables.
My Query is:
Select id1 , count(*)
(Select id2 as id1 , count(*)
Select id3 as id1 , count(*)
Where id1= 4
Will the index available on site2 be used correctly and only the records that
Answer the filter will be sent via the network ?
I know that using this tmplate of query where both tables are on the same Db
The index is used.