Home » RDBMS Server » Performance Tuning » to determine join order for tuning
to determine join order for tuning [message #345115] Tue, 02 September 2008 06:21 Go to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
how to determine join order in where clause......and whether small table should be kept first or big table in from clause

What is driving table?

[Updated on: Tue, 02 September 2008 06:22]

Report message to a moderator

Re: to determine join order for tuning [message #345117 is a reply to message #345115] Tue, 02 September 2008 06:24 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
http://www.orafaq.com/faq/performance_tuning[/a]
Please go through the above link.

Regards,
Oli
Re: to determine join order for tuning [message #345137 is a reply to message #345115] Tue, 02 September 2008 06:55 Go to previous messageGo to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
i have already checked this link but it is not specified there
Re: to determine join order for tuning [message #345140 is a reply to message #345137] Tue, 02 September 2008 07:04 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
http://www.orafaq.com/tuningguide/
Problem and Fixes > MULTIPLE TABLE JOIN


[http://www.orafaq.com/tuningguide/five%20tables.html]


Regards,
Oli
Re: to determine join order for tuning [message #345437 is a reply to message #345140] Wed, 03 September 2008 10:32 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Why do you think you need to determine the join order?

If you want to see it, then look at the Explain Plan (visible in v$sql_plan, or from the Plan Table.

Unless you have a hint such as Leading, or Ordered, the order in which you list the tables makes no difference at all.
Re: to determine join order for tuning [message #345855 is a reply to message #345437] Fri, 05 September 2008 02:16 Go to previous message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
I m talking about order in where clause
for eg suppose my query is
select * from a,b
where a.id = b.id

a is small table and b is big table

then writing a.id = b.id is good for reducing time
or b.id = a.id

[Updated on: Fri, 05 September 2008 04:25]

Report message to a moderator

Previous Topic: tunning
Next Topic: help in tuning procedure
Goto Forum:
  


Current Time: Sun Dec 11 00:27:32 CST 2016

Total time taken to generate the page: 0.11667 seconds