Re: Optimization question: Unrolling subquery into IN clause
From: madhu <madhusreeram_at_gmail.com>
Date: Fri, 16 Oct 2009 15:06:51 -0700 (PDT)
Message-ID: <80c66c85-6c41-47c5-b9c2-03bc2058c766_at_j19g2000yqk.googlegroups.com>
Date: Fri, 16 Oct 2009 15:06:51 -0700 (PDT)
Message-ID: <80c66c85-6c41-47c5-b9c2-03bc2058c766_at_j19g2000yqk.googlegroups.com>
Try adding a hint - /*+ index(tab1 index_name_on_col2) */, so Oracle
chooses the index on col2.
So the query would be:
SELECT /*+ index(tab1 index_name_on_col2) */ several_columns
...
-Madhu Sreeram Received on Fri Oct 16 2009 - 17:06:51 CDT