Now, I'm running this query to get all the values. It shows the columns (log_id, log_desc, log_date, cust_id, rgn_id, rgn_name, rgn_type, cust_id, cust_name, cust_phone, lookup_name ) but does not populate the id-values coming from the idx_2 index. Please let me know if I'm doing anything wrong here.
Thanks MuS for your response! I'm not trying to join the indexes to get the UNION of two sets, but I wanted to do the left join to get the specific details of given cust_id/rgn_id. The problem I'm facing is with bigger set of data. If the data-set is smaller then I get the desired results but if the data is in few millions, then the sub-search does not work.