Is it correct, order of where clause doesn't matter when it is used with join?
The order of items in the where clause should not make a difference, especially if you use the preferred join syntax as follows:

select a.col1, 
       b.col2 
 from table1 a 
 join table2 b on b.col1 = a.col1
where a.col3 = 10


This keeps the join conditions separated from the filters.