Hi All, As of now, we have less than 1 M records , and attribute split into few(3) tables with index created. We are using combination of join & IN clause(sub query) in the SQL query , for some reason this query does not return any response. But, the moment we remove the IN clause and use just the join, the query returns the result. Note that as per EXPLAIN PLAN , the sub query also seems to be using the defined indexes.
What are the recommendations for using such queries , are there any guidelines, What we are doing wrong here? Thanks, Rajesh
