| Speed Diffrence [message #276472] |
Thu, 25 October 2007 04:47  |
nirajksharmacpr
Messages: 19
Registered: October 2007
Location: Mumbai
|
Junior Member |
|
|
Hi All
Just suggest me Which one if Better For PT(Performance Tuning) point
Thnx n Sorry i am Just Changing in my question and add this thing in the query as Requirment
1.[b]select * from a Natural join b Natural join c
2.select * from a , b, c where a.id=b.id and b.id =a.id
In Our Application 2nd No Query is Using But i want to Replace with 1 No Query . So Please Suggest.
Thnx n Regrads
[Updated on: Thu, 25 October 2007 04:57] Report message to a moderator |
|
|
|
|
|
| Re: Speed Diffrence [message #276670 is a reply to message #276475] |
Thu, 25 October 2007 22:46  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
ANSI join syntax is no more or less performant than the old syntax.
Personally, I prefer not to use NATURAL joins as it joins on all columns in the tables with the same name. You often find that tables have meta-data columns with the same name (eg. DATE_UPDATED) that you do not want in the join criteria.
If you wanted to change to INNER JOIN syntax though, all you are affecting is aesthetics, not performance.
Ross Leishman
|
|
|
|
| Re: Speed Diffrence [message #276700 is a reply to message #276472] |
Fri, 26 October 2007 00:51 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
In the original post, query 1 was with outer join and not natural one.
Please do NOT modify the original post, add a new one.
Modifying the original post you turn the following posts ununderstandable.
In addition, when you modified you could read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Regards
Michel
[Updated on: Fri, 26 October 2007 00:53] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
