Hello.
Did you read all promptings at: http://dev.mysql.com/doc/mysql/en/Full_table.html "Manish" <[EMAIL PROTECTED]> wrote: > I am trying to execute this query and it is failing with Table is full error > (I know I can make temp tables big). > update t1, t2 > set t1.XXX=1 > where t1.YYY=t2.ZZZZ and t2.AAAA like '%X%'; > > My t1 has 10,00,000+ records and t2 has about 70,000 records. I would like > to know how can I optimize this query? > What are the parameters for this optimization? Can someone give me links > where I can read up about such optimizations for update query. > > TIA, > - Manish > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
