>
> AND Substring(a.mob, 1, 4) = b.mob_series
>
There's what is probably the major problem with your query: your join
condition. Indices (you *do* have them on your join fields, don't you ?)
only work on the entire field you've indexed.
Function indices are not supported in MySQL, so you'll
Hello,
Starting today, my daily database backup script does not work :-( with
mysqldump typically Out of memory error.
So, I try to change max_allowed_packet option value, but I don't succeed
(mysql run on ubuntu 10.04 OS with 5.1.41-3ubuntu12.7 0 mysql version.)
On the last successfull backu
using Execution plan:
++++-+---++-+---+-+-
---+
| id | select_type| table | type|
possible_keys | key| key
Hi All,
Following query take 25 minutes time,in this table having 3 core
records,how to speed up this query,please help me.thanks advance
SELECT b.circle_name,
COUNT(a.mob),
a.pack_price,
DATE(a.req_date)
FROM user_info_table a,
circle_info_table b
WHERE a.