This content has been marked as final. Show 1 reply
First off, they produce different results unless you can guarantee that your first query returns exactly 1 row for every element in the L_PARTY_TAB collection. But if you can guarantee that, there would seem to defeat the purpose of the query if you are saying that you are trying to determine whether the elements of the collection are present in the table.
Second, given your tables, your data, and your process, what do your benchmarks tell you? Which one runs faster?
Third, since the collection has a very small number of elements, you would probably want to use a CARDINALITY hint in the second query to let the optimizer know that the collection is going to be very small.