SQL查询快速选择百万条记录 [英] SQL query to select million records quickly

问题描述

我想从一个表中选择百万条记录，我为此使用了 select 查询.

I want to select million records from a table and I am using select query for this.

目前获取数据需要几分钟时间.能快点拿到吗?

Currently it is taking a few minutes to get data. Can I get it quickly?

我使用的是 SQL Server 2008 R2.

I am using SQL Server 2008 R2.

我的查询:

SELECT     
   sum(Orders.BusinessVolumeTotal) as  BusinessVolume, 
   sum(Orders.CommissionableVolumeTotal) as CommissionableVolume, 
   OrderTypes.OrderTypeDescription, 
   Orders.OrderTypeID
FROM  
   Orders 
INNER JOIN
   OrderTypes ON Orders.OrderTypeID = OrderTypes.OrderTypeID
WHERE
   Orders.OrderDate > convert(DATETIME, '{0}') 
   and Orders.OrderDate < convert(DATETIME, '{1}') 
GROUP BY
   Orders.OrderTypeID, OrderTypes.OrderTypeDescription

推荐答案

对表字段使用索引以快速获取数据.

Use Indexing for your table fields for fetching data fast.

参考:

http://www.tutorialspoint.com/sql/sql-indexes.htm

这篇关于SQL查询快速选择百万条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！