Re:Speed Up Query

[kranthi kiran]

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.status = 'SUCCESS'
       AND a.sub_type IN( 'SUB', 'RESUB' )
       AND Substring(a.mob, 1, 4) = b.mob_series
       AND DATE(a.req_date) = '2010-11-09'
       AND a.pack_id IN ( '206' )
       AND mob NOT IN (SELECT mob
                          FROM   demo_user_info_table)
GROUP  BY a.pack_price,
          b.circle_name,
          DATE(a.req_date);