Mean I heard from Oracle 8i onwards the order of where clause condition does not matter which oracle creates the explain plan...and execute..Is it true?

manoj_behera82

 Profile Answers by manoj_behera82 Questions by manoj_behera82

• Aug 7th, 2008

Yes the order is important. But it is important for the performance of the query and not for the final result. The output of the query will be the same irrespective of the order in which the join con...

gtomar

 Profile Answers by gtomar Questions by gtomar

• Aug 7th, 2008

Hi, Where Clause conditions execution are independent of order in explain plan but it reads top to bottom.Thanks,Gunjan

Answer Question  Select Best Answer