Is inner Join faster than where clause ?
876094Apr 30 2013 — edited Apr 30 2013For Example, Consider the below two queries and say me which query runs faster
Predicate in Inner Join on Clause:
select * from tabl1 abc join tabl2 def on (abc.column1=def.column1 and def.column3='abc')
Predicate in where Clause:
select * from tabl1 abc join tabl2 def on (abc.column1=def.column1)
where def.column3='abc'
Hint:
1. Column3 in tabl2 is non-indexed
Thanks in Advance
Thirumurugan Desinghu