Index for adhoch join

Couchbase Server
, ,
1

if i need to perform join query between patients and encounter what is the best index to perform adhoc query

SELECT patients. FIRST_NAME,

   patients. LAST_NAME,

   encounters. PATIENT

FROM patients

JOIN encounters ON patients. Id = encounters. PATIENT

thanks

2

https://index-advisor.couchbase.com/indexadvisor/#1