Improve query

2010-09-16 Thread Tompkins Neil
Hi, Regarding my query below, is there anyway in which this query can be improved ? SELECT t1.players_brought, t2.players_sold, t3.team_balance, t4.home_team_wages, t5.away_team_wages, (t3.team_balance+t2.players_sold)-(t1.players_brought+t4.home_team_wages+t5.away_team_wages) AS team_balance, t6

how to improve query performance

2001-07-09 Thread purushottam naktode
Hi, I am pretty new to mySql. (In fact just built a databse and started working on it). I want to do keyword search on a column (clob). It may contain millions of records. How do I write query so that it is efficient. Thanks in advance for your time, Puru. __