Hello,
Oracle DBMS: 12.1.0.1.5
I have a table with about 35 million records. One query has five limitations in the WHERE clause. Three of them are comparing them with bind variables and the other two have an IN operator with a subquery (that subquery uses bind variables, but it is not corrolated). An index over all 5 columns exist. What the optimizer is doing, he is using the index with the 3 conditions without the subquery and after that filter the records with the other 2 conditions from the subquery .But it is very importend for the performance of the query, that the two subqueries will be executed before he is using that index. So I found the undocumented hint PRECOMPUTE_SUBQUERY. And in 12c it is working with that hint. My question is, I dont think the hint works in 11g. But I am not sure about it, cause it is not documented. Can anyone confirm that the hint is working only since 12c and is there any hint for 11g, so the subqueries will be executed first ?
sql_coder