Query Tuning - outer join
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
Re: Query Tuning - outer join
Quote:
Originally posted by ananthkt_sat
As want tune this with in half-day,pls try send some tips & suggestions imm.
Thanks in advance
oh and asking for time limit huh?