Optimize SELECE SQL Query

Hi,

Oracle client Version 9, OS WinXP, About 6 million rows, index on a.name.

I have a following SQL query.

Select a.id,a.name,a.age,a.class,a.tel from table01 a, table02 b where a.name=USER and (a.id=b.id01 or a.id=b.id02 or a.id=b.id03 or a.id=b.id04 or a.id=b.id05 or. a.id=b.id06)

The above query took long time.

How can I optimize this for better result?

Thanks. Received on Tue Apr 24 2007 - 07:39:07 CDT