突然,当我尝试运行这个查询时,它开始挂起。如果我移除左联接,并执行常规连接,它将以正常的速度运行。但是我没有得到想要的结果
问题是它通常运行得很好。当我解释的时候,一切看起来都很好。SELECT a.art_id AS art_id, a.ecs_id AS ecs_id, a.parent_id AS parent_id, a.primarytext AS primarytextutprisTodate, pp.price AS innpris, pp.fromdate AS innprisFromdate, pp.todate AS i
我有一个查询,我对子字符串进行连接,问题是这真的很慢。有没有更有效的方式来写这篇文章呢?SELECT *, SUM(s.pris*s.antall) AS total, SUM(s.antall) AS antallJOIN butikk_ordreAS bo ON ordreId=bo.ecs_ordre_id AND butikkNr=bo.site_id
JOIN ecs_supplier AS l ON SUBSTRING( s.artikkelId