Performance in joining more than 7 tables
Hi,
In a query I need to join around 7 tables. There are some other conditions also. My query is not running that fast. To return around 450 rows oracle takes around 1.1 seconds for a remote database. I want it to be be executed in milliseconds.
How can I improve the performance?
What should be my joining order? Is there any impact on joining order?
Will hint give me performance gain?
Please suggest.
I am using oracle 9i in windows.