[thelist] Oracle "in" question & owed tip

listman at hazard0us.org listman at hazard0us.org
Tue Nov 5 08:47:01 CST 2002


>Now I need to change one of the where conditions from
>"Account_ID = '1234567890'" to
>"Account_ID IN ('1234567890', '2345678901')".
>It's killing the performance.

Is there an index on the Account_ID column ?
Maybe thats the reason for the poor performance

------
Ashok Hariharan
http://www.unganisha.org
------






More information about the thelist mailing list