临时表以加速此查询
临时表以加速此查询
提问于 2016-08-09 23:45:32
这个基本查询在我将job_price_line连接到job_price_hdr之后抛出了一个System.OutOfMemoryException错误
创建临时表会加快这个查询的速度吗？我不理解我读过的关于这个话题的其他解释。谢谢!
select
oe_line.qty_invoiced,
invoice_hdr.invoice_no,
invoice_hdr.invoice_date,
invoice_line.unit_price,
invoice_line.item_desc,
invoice_line.customer_part_number,
invoice_line.pricing_unit,
invoice_hdr.ship_to_id,
invoice_hdr.po_no,
invoice_hdr.ship_to_id,
invoice_line.item_id,
invoice_hdr.customer_id,
job_price_hdr.contract_no,
job_price_hdr.cancelled,
job_price_line.line_no,
invoice_hdr.sales_location_id
from invoice_hdr
join invoice_line on invoice_line.invoice_no = invoice_hdr.invoice_no
join oe_line on oe_line.order_no = invoice_hdr.order_no
join job_price_hdr on job_price_hdr.corp_address_id = invoice_hdr.corp_address_id
join job_price_line on job_price_line.job_price_hdr_uid = job_price_hdr.job_price_hdr_uid
where invoice_hdr.invoice_date between ('2016-05-02') and ('2016-05-03')
and job_price_hdr.cancelled = 'N'
and invoice_hdr.sales_location_id = '200'回答 1
Stack Overflow用户
发布于 2016-08-09 23:57:12
无论速度如何，都会解决内存不足的异常。看起来你的最后一次连接大大增加了你返回的记录的数量。尝试将字段列表替换为count(*)，以查看您首先返回了多少条记录。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/38855189
复制相关文章
相似问题
腾讯云开发者
