新建了一个存储过程，然后运行，很长时间都没有运行出结果，求解

BEGIN

  delete from newactive_day
  where datrpt = date_format(str_to_date(varday,'%Y%m%d'),'%Y-%m-%d');
   
  insert into newactive_day(datrpt,intnewactive)
  select date_format(str_to_date(varday,'%Y%m%d'),'%Y-%m-%d'),count(distinct u.login_name)
  FROM user u
  where date_format(u.lastlogin,'%Y-%m-%d')=date_format(str_to_date(varday,'%Y%m%d'),'%Y-%m-%d') 
  GROUP BY date_format(str_to_date(varday,'%Y%m%d'),'%Y-%m-%d');

END

delete from newactive_day
  where datrpt = date_format(str_to_date(varday,'%Y%m%d'),'%Y-%m-%d');
看一下句的执行计划。可能要花很长时间。

还有该建的索引别忘了。