Optimize query with JOIN

GSI need Disk/Memory Intensive,Average CPU Utilization
And Index Service deploy with Query service is better compared to Data Service.
The aim to keep index data in memory.

FYI
In 06_WS_Index_Manageability.