34,838
社区成员




select id,[收货人名称] ,[申报日期] ,[商品编码] ,[价格] FROM dbo.dc_Russia WHERE [申报日期] between '2010-1-1 0:00:00' and '2011-8-11 0:00:00' and [商品编码]='9026'
CREATE NONCLUSTERED INDEX [index_hs_date] ON [dbo].[dc_Russia]
(
[商品编码] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [Data_Partition_Scheme]([申报日期])
CREATE NONCLUSTERED INDEX [idx_colombia_hs] ON [dbo].[dc_Colombia]
(
[NANDINA ] ASC,
[Date Declaration ] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
CREATE NONCLUSTERED INDEX [index_hs_date] ON [dbo].[dc_Russia]
(
[商品编码] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [Data_Partition_Scheme]([申报日期])
INCLUDE (id,[收货人名称] ,[申报日期] ,[商品编码] ,[价格] )
select id,[收货人名称] ,[申报日期] ,[商品编码] ,[价格]
FROM dbo.dc_Russia(index [index_hs_date] )
WHERE [申报日期] between '2010-1-1 0:00:00' and '2011-8-11 0:00:00' and [商品编码]='9026'