t***u
发帖数: 368 | 1 blow query is VERY slow： > 15 mins, any suggestions appreciated !!
@tempTable ~ 20k data
#ExpTable ~ 500k data
declare @tempTable table
(
data_id int,
Q float,
Qtype int
)
create table #ExpTable
(
data_id int,
B1 float,
B2 float,
B3 float,
B4 float,
B5 float,
B6 float,
B7 float,
B8 float,
B9 float,
B10 float
)
... 阅读全帖 |
|
