Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Gochi Bewarse Legend Username: Gochi Post Number: 78651 Registered: 07-2004 Rating: N/A Votes: 0 Posted on Tuesday, September 11, 2012 - 2:17 pm:    pedda query lo where clause lo pass chesthunnaaru kadhaa like '%..' ani... alaa kaakundaa what if you pass the filter in the From clause...does it improve performance Original Query: select * from a,b,c,d where a.name like 'Sachin%' New Query: select * from (select a.* from a where name like 'Sachin%') a b,c,d