Hi,
I have a base table with 10,000 rows.The base table columns will store 8 diff IDs.To display with the description i'm doing outer joining with 8 tables.
In that 8 one table contains nearly 4 lakhs rows & rest of the tables contains some 100 rows.
My query takes nearly 20 min. to execute. HOw to tune that.

As want tune this with in half-day,pls try send some tips & suggestions imm.

Thanks in advance