dongyi1524 2014-07-08 07:04
浏览 58

内连接上的MySql数据库优化

I am facing problem while running the below query. It takes longer time for short month duration and time out for longer duration.

SELECT DISTINCT rcs.ID,
                rcs.UniqueID,
                rcs.ReferanceNo,
                rcs.OrderDateActual,
                rcs.DelivaredToCus,
                rcs.PacketNumber,
                rcs.PackingCharge,
                rcs.TransportCharge,
                rcs.OtherAdjustment,
                SUM(rcsd.TotalPrice) AS TotalPrice
FROM regular_challan_sales rcs
LEFT JOIN regular_challan_sales_details rcsd ON rcsd.UniqueID = rcs.UniqueID
WHERE rcs.OrderDateActual >= '2013-12-01'
  AND rcs.OrderDateActual <= '2014-05-01'
GROUP BY rcs.UniqueID
ORDER BY rcs.OrderDateActual ASC

Here is the table description.

I need a quick solution please.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端
    • ¥15 基于PLC的三轴机械手程序
    • ¥15 多址通信方式的抗噪声性能和系统容量对比