sql query optimisation

Please compare the following:

INNER JOIN table1 t1 ON t1.someID LIKE 'search.%' AND 
                        t1.someID = ( 'search.' || t0.ID )

vs.

INNER JOIN table1 t1 ON t1.someID = ( 'search.' || t0.ID )

I've been told, that the first case is optimized. But you know, I can not understand why it is. As far as I understand the 2nd example should run faster.

We use Oracle, but I suppose it does not matter at the moment.

Please explain if I'm wrong.

Thank you

5
задан Alexandr 5 May 2011 в 05:43
поделиться