慢sql更新MS SQL 2000 [英] slow sql update MS SQL 2000

问题描述

我有以下声明需要很长时间。我的任何SQL语句更新最长

。

更新F_REGISTRATION_STD_SESSION

SET PREVIOUS_YEAR_SESSION_ID =（

SELECT s.previous_year_session_id

来自F_REGISTRATION_STD_SESSION R

，DS_V4_TARGET.dbo.D_H_Session_By_SessQtr S

WHERE

r。 STUDENT_ID = F_REGISTRATION_STD_SESSION.STUDENT_ID

和s.previous_year_SESSION_ID = r.SESSION_ID

和s.session_id = F_REGISTRATION_STD_SESSION.SESSION_ID

）

STUDENT_ID varchar（20）和SESSION_ID char（10）并被编入索引

我想要完成的任务：

我想知道是否有学生注册从上一年

注册。

例如，如果有2004年秋季的注册，那么还有一个

注册同一个学生2003年秋天？

也许有更好的方法来解决这个问题？

TIA

Rob

I have the following statement that takes quite a long time. Longest
of any of my SQL statment updates.

UPDATE F_REGISTRATION_STD_SESSION
SET PREVIOUS_YEAR_SESSION_ID = (
SELECT s.previous_year_session_id
FROM F_REGISTRATION_STD_SESSION R
,DS_V4_TARGET.dbo.D_H_Session_By_SessQtr S
WHERE
r.STUDENT_ID = F_REGISTRATION_STD_SESSION.STUDENT_ID
and s.previous_year_SESSION_ID = r.SESSION_ID
and s.session_id = F_REGISTRATION_STD_SESSION.SESSION_ID
)
STUDENT_ID varchar(20) and SESSION_ID char(10) and are indexed
What I want to accomplish:
I want to know if there was a student registration from the prior year
of a registration.
Example, if there is a registration for Fall 2004, was there also a
registration for the same student Fall 2003?
Maybe there is a better way to approach this?
TIA
Rob

推荐答案

R Camarda（rc******@cablespeed.com）写道：

R Camarda (rc******@cablespeed.com) writes:

我有以下声明需要很长时间。我的任何SQL语句更新中最长的。

UPDATE F_REGISTRATION_STD_SESSION
SET PREVIOUS_YEAR_SESSION_ID =（
SELECT s.previous_year_session_id
FROM F_REGISTRATION_STD_SESSION R
，DS_V4_TARGET.dbo.D_H_Session_By_SessQtr S
其中r.STUDENT_ID = F_REGISTRATION_STD_SESSION.STUDENT_ID
和s.previous_year_SESSION_ID = r.SESSION_ID
和s.session_id = F_REGISTRATION_STD_SESSION.SESSION_ID ）
STUDENT_ID varchar（20）和SESSION_ID char（10）并被编入索引
我想要完成的事情：
我想知道上一年是否有学生注册例如，如果有2004年秋季的注册，同一个学生2003年秋季也有注册吗？
也许有更好的方法来解决这个问题？

I have the following statement that takes quite a long time. Longest
of any of my SQL statment updates.

UPDATE F_REGISTRATION_STD_SESSION
SET PREVIOUS_YEAR_SESSION_ID = (
SELECT s.previous_year_session_id
FROM F_REGISTRATION_STD_SESSION R
,DS_V4_TARGET.dbo.D_H_Session_By_SessQtr S
WHERE
r.STUDENT_ID = F_REGISTRATION_STD_SESSION.STUDENT_ID
and s.previous_year_SESSION_ID = r.SESSION_ID
and s.session_id = F_REGISTRATION_STD_SESSION.SESSION_ID
)
STUDENT_ID varchar(20) and SESSION_ID char(10) and are indexed
What I want to accomplish:
I want to know if there was a student registration from the prior year
of a registration.
Example, if there is a registration for Fall 2004, was there also a
registration for the same student Fall 2003?
Maybe there is a better way to approach this?

如果不知道表格，很难说清楚。如果您发布了以下内容，这将有助于

很多：


o这两个表的CREATE TABLE语句。

o所有约束和索引表（作为SQL状态）。

o包含样本数据的INSERT语句。

o样本的所需输出。

o行数每个表格。


样本没有大到足以证明问题，

只是为了有助于测试重写查询。

-

Erland Sommarskog，SQL Server MVP， es **** @ sommarskog .se


SQL Server SP3联机丛书
http://www.microsoft.com/sql/techinf...2000/books.asp

您好


发布您的ddl（创建表语句等）和示例数据（作为插入

语句）将h elp在解决这个问题。我认为您的

声明可以简化为：


更新R

SET PREVIOUS_YEAR_SESSION_ID = s.previous_year_session_id

来自F_REGISTRATION_STD_SESSION R

加入DS_V4_TARGET.dbo.D_H_Session_By_SessQtr S ON s.session_id =

R.SESSION_ID

加入F_REGISTRATION_STD_SESSION P ON s .previous_year_session_id =

P.session_id

AND R.STUDENT_ID = P.STUDENT_ID


查看查询计划，看看是否你的索引正在被使用，但是你没有给出关于D_H_Session_By_SessQtr索引的任何指示。


如果你的session_ids在几年之间没有变化那么你不应该需要

D_H_Session_By_SessQtr，但你需要保持年份

F_REGISTRATION_STD_SESSION。


John


" R Camarda" < RC ****** @ cablespeed.com>在消息中写道

news：d7 ************************** @ posting.google.c om ...

Hi

Posting your ddl (Create table statements etc..) and example data (as insert
statements) would help in the solution of this problem. I think your
statement can be simplyfied to:

UPDATE R
SET PREVIOUS_YEAR_SESSION_ID = s.previous_year_session_id
FROM F_REGISTRATION_STD_SESSION R
JOIN DS_V4_TARGET.dbo.D_H_Session_By_SessQtr S ON s.session_id =
R.SESSION_ID
JOIN F_REGISTRATION_STD_SESSION P ON s.previous_year_session_id =
P.session_id
AND R.STUDENT_ID = P.STUDENT_ID

Look at the query plan to see if your indexes are being used, but you have
not given any indication on what is indexed on D_H_Session_By_SessQtr.

If your session_ids do not change between years then you should not need
D_H_Session_By_SessQtr but you will need to hold the year in
F_REGISTRATION_STD_SESSION.

John

"R Camarda" <rc******@cablespeed.com> wrote in message
news:d7**************************@posting.google.c om...

我有以下声明需要很长时间。我的任何SQL语句更新中最长的。

UPDATE F_REGISTRATION_STD_SESSION
SET PREVIOUS_YEAR_SESSION_ID =（
SELECT s.previous_year_session_id
FROM F_REGISTRATION_STD_SESSION R
，DS_V4_TARGET.dbo.D_H_Session_By_SessQtr S
其中r.STUDENT_ID = F_REGISTRATION_STD_SESSION.STUDENT_ID
和s.previous_year_SESSION_ID = r.SESSION_ID
和s.session_id = F_REGISTRATION_STD_SESSION.SESSION_ID ）
STUDENT_ID varchar（20）和SESSION_ID char（10）并被编入索引
我想要完成的事情：
我想知道上一年是否有学生注册例如，如果有2004年秋季的注册，同一个学生2003年秋季也有注册吗？
也许有更好的方法来解决这个问题？
TIA
Rob

I have the following statement that takes quite a long time. Longest
of any of my SQL statment updates.

UPDATE F_REGISTRATION_STD_SESSION
SET PREVIOUS_YEAR_SESSION_ID = (
SELECT s.previous_year_session_id
FROM F_REGISTRATION_STD_SESSION R
,DS_V4_TARGET.dbo.D_H_Session_By_SessQtr S
WHERE
r.STUDENT_ID = F_REGISTRATION_STD_SESSION.STUDENT_ID
and s.previous_year_SESSION_ID = r.SESSION_ID
and s.session_id = F_REGISTRATION_STD_SESSION.SESSION_ID
)
STUDENT_ID varchar(20) and SESSION_ID char(10) and are indexed
What I want to accomplish:
I want to know if there was a student registration from the prior year
of a registration.
Example, if there is a registration for Fall 2004, was there also a
registration for the same student Fall 2003?
Maybe there is a better way to approach this?
TIA
Rob

//连接：3-Staging


创建表dbo。F_Registration_STD_Session

（

" REGISTRATION_KEY" VARCHAR（41）NULL，

" STUDENT_ID" VARCHAR（20）NULL，

" SESSION_ID" VARCHAR（20）NULL，

" LOAD_DT" DATETIME NULL，

" CLASS_ADD_COUNT" INTEGER NULL，

" CLASS_DROP_COUNT" INTEGER NULL，

" BEFORE_D0_CLASS_COUNT" INTEGER NULL，

" DAY0_CLASS_COUNT" INTEGER NULL，

" AFTER_D0_CLASS_COUNT" INTEGER NULL，

" ALL_CLASS_COUNT" INTEGER NULL，

" BEFORE_D0_ONLINE_CLASS_COUNT" INTEGER NULL，

" DAY0_ONLINE_CLASS_COUNT" INTEGER NULL，

" AFTER_D0_ONLINE_CLASS_COUNT" INTEGER NULL，

" ALL_ONLINE_CLASS_COUNT" INTEGER NULL，

" CLASS_NOSHOW_COUNT" INTEGER NULL，

" CLASS_WITHDRAW_COUNT" INTEGER NULL，

" COMPLETE_WITHDRAW_COUNT" INTEGER NULL，

" COMPLETE_NOSHOW_COUNT" INTEGER NULL，

" STUDENT_WITHDRAW_COUNT" INTEGER NULL，

" BEFORE_D0_ONLINE_ONLY_CLASS_CNT" INTEGER NULL，

" DAY0_ONLINE_ONLY_CLASS_COUNT" INTEGER NULL，

" AFTER_D0_ONLINE_ONLY_CLASS_COUNT" INTEGER NULL，

" ALL_ONLINE_ONLY_CLASS_COUNT" INTEGER NULL，

" SESSION_SKEY" INTEGER NULL，

" NEXT_REGISTERED_SESSION_SKEY" INTEGER NULL，

" PREV_REGISTERED_SESSION_SKEY" INTEGER NULL，

" SESSIONS_SKIPPED_NEXT" INTEGER NULL，

" SESSIONS_SKIPPED_PREV" INTEGER NULL，

" CLASS_ADD_DT" DATETIME NULL，

" CLASS_DROP_DT" DATETIME NULL，

" STUDENT_SKEY" INTEGER NULL，

" PREVIOUS_YEAR_SESSION_ID" VARCHAR（10）NULL，

" NEXT_YEAR_SESSION_ID" VARCHAR（10）NULL，

" CAMPUS_SKEY" INTEGER NULL，

" ACTIVITY_DT" DATETIME NULL，

" CAMPUS_ID" VARCHAR（2）NULL

）


CREATE INDEX ix1F_Registration_STD_Session ON

" dbo"。" F_Registration_STD_Session" （" STUDENT_ID"）;

CREATE INDEX ix2F_Registration_STD_Session ON

" dbo"。" F_Registration_STD_Session" （" SESSION_ID"）;

CREATE INDEX ix3F_Registration_STD_Session ON

" dbo"。" F_Registration_STD_Session" （" NEXT_REGISTERED_SESSION_SKEY"）;

CREATE INDEX ix4F_Registration_STD_Session ON

" dbo"。" F_Registration_STD_Session" （" PREV_REGISTERED_SESSION_SKEY"）;

CREATE INDEX ix5F_Registration_STD_Session ON

" dbo"。" F_Registration_STD_Session" （" STUDENT_SKEY"）;

CREATE INDEX ix6F_Registration_STD_Session ON

" dbo"。" F_Registration_STD_Session" （" PREVIOUS_YEAR_SESSION_ID"）;

CREATE INDEX ix7F_Registration_STD_Session ON

" dbo"。" F_Registration_STD_Session" （" NEXT_YEAR_SESSION_ID"）;

CREATE INDEX ix8F_Registration_STD_Session ON

" dbo"。" F_Registration_STD_Session" （" CAMPUS_SKEY"）;

CREATE INDEX STUDENT_ID ON&qu​​ot; dbo"。" F_Registration_Session_Lookup" （

" STUDENT_ID"）;

CREATE INDEX SESSION_ID ON&qu​​ot; dbo"。" F_Registration_Session_Lookup" （

" SESSION_ID"）

CREATE TABLE" dbo"。D_H_Session_By_SessQtr"

（

" SESSION_SKEY" INTEGER NULL，

" SESSION_CAPTION&qu​​ot; VARCHAR（19）NULL，

" SESSION_ID" VARCHAR（20）NULL，
" SESSION_YEAR" VARCHAR（20）NULL，

" SESSION_START_DT" DATETIME NULL，

" SESSION_END_DT" DATETIME NULL，

" SESSION_AddDrop_DT" DATETIME NULL，

" SESSION_DROP_DT" DATETIME NULL，

" SESSION_PNOTE_DUE1_DT" DATETIME NULL，

" SESSION_PNOTE_DUE2_DT" DATETIME NULL，

" SESSION_PNOTE_DUE3_DT" DATETIME NULL，

" SESSION_QTR" VARCHAR（20）NULL，

" SESSION_QTR_CAPTION&qu​​ot; VARCHAR（23）NULL，

" All_id" VARCHAR（3）NULL，

" All_caption" VARCHAR（21）NULL，

" SESSION_ID_CAPTION" VARCHAR（50）NULL，

" PREVIOUS_SESSION_ID" VARCHAR（10）NULL，

" NEXT_SESSION_ID" VARCHAR（10）NULL，

" PREVIOUS_SESSION_SKEY" NUMERIC（19）NULL，

" NEXT_SESSION_SKEY" NUMERIC（19）NULL，

" PREVIOUS_YEAR_SESSION_ID" VARCHAR（10）NULL，

" NEXT_YEAR_SESSION_ID" VARCHAR（10）NULL，

" PREVIOUS_YEAR_SESSION_SKEY" NUMERIC（19）NULL，

" NEXT_YEAR_SESSION_SKEY" NUMERIC（19）NULL

）

;

CREATE INDEX ix1D_H_Session_By_SessQtr ON

" dbo"。" D_H_Session_By_SessQtr" （" SESSION_SKEY"）;

CREATE INDEX ix2D_H_Session_By_SessQtr ON

" dbo"。" D_H_Session_By_SessQtr" （" SESSION_QTR"）;

CREATE INDEX ix3D_H_Session_By_SessQtr ON

" dbo"。" D_H_Session_By_SessQtr" （" All_id"）;

CREATE INDEX PREVIOUS_YEAR_SESSION_ID ON

" dbo"。" D_H_Session_By_SessQtr" （PREVIOUS_YEAR_SESSION_ID）;

CREATE INDEX NEXT_YEAR_SESSION_ID ONdbo。D_H_Session_By_SessQtr" （

" NEXT_YEAR_SESSION_ID"）

[EXECUTEDSQ - 07:23:54]数据插页


insert到dbo。F_Registration_STD_Session （" REGISTRATION_KEY"，

" STUDENT_ID"，" SESSION_ID"，" LOAD_DT"，" CLASS_ADD_COUNT"，

" CLASS_DROP_COUNT"，" BEFORE_D0_CLASS_COUNT" ;，DAY0_CLASS_COUNT，

" AFTER_D0_CLASS_COUNT"，" ALL_CLASS_COUNT"，

" BEFORE_D0_ONLINE_CLASS_COUNT"，" DAY0_ONLINE_CLASS_COUNT"，$ / $
" AFTER_D0_ONLINE_CLASS_COUNT"，" ALL_ONLINE_CLASS_COUNT"，

" CLASS_NOSHOW_COUNT"，" CLASS_WITHDRAW_COUNT"，

" COMPLETE_WITHDRAW_COUNT"，" COMPLETE_NOSHOW_COUNT"，&br / >
" STUDENT_WITHDRAW_COUNT"，" BEFORE_D0_ONLINE_ONLY_CLASS_CNT" ;,

" DAY0_ONLINE_ONLY_CLASS_COUNT"，" AFTER_D0_ONLINE_ONLY_CLASS_COUNT" ;,

" ALL_ONLINE_ONLY_CLASS_COUNT"，" SESSION_SKEY" ，

" NEXT_REGISTERED_SESSION_SKEY"，" PREV_REGISTERE D_SESSION_SKEY"，

" SESSIONS_SKIPPED_NEXT"，" SESSIONS_SKIPPED_PREV"，" CLASS_ADD_DT"，

" CLASS_DROP_DT"，" STUDENT_SKEY"，" PREVIOUS_YEAR_SESSION_ID"，

NEXT_YEAR_SESSION_ID，CAMPUS_SKEY，ACTIVITY_DT，CAMPUS_ID）

值（？，？，？，？，？，？，？ ，？，？，？，？，？，？，？，？，？，？，？，？，？，？，

？，？，？，？，？，？，？ ，？，？，？，？，？，？，？，？）

[EXECUTEDSQ - 07:26:20]检查现有尺寸表行

选择SESSION_SKEY，SESSION_CAPTION，SESSION_ID，

SESSION_YEAR，SESSION_START_DT，SESSION_END_DT，

" SESSION_AddDrop_DT"，" SESSION_DROP_DT"，" SESSION_PNOTE_DUE1_DT"，$ / b $ b" SESSION_PNOTE_DUE2_DT"，" SESSION_PNOTE_DUE3_DT"，" SESSION_QTR"，>
" SES SION_QTR_CAPTION&qu​​ot;，" All_id"，" All_caption"，" SESSION_ID_CAPTION&qu​​ot;，

" PREVIOUS_SESSION_ID"，" NEXT_SESSION_ID"，" PREVIOUS_SESSION_SKEY"，

" ; NEXT_SESSION_SKEY"，" PREVIOUS_YEAR_SESSION_ID"，

" NEXT_YEAR_SESSION_ID"，" PREVIOUS_YEAR_SESSION_SKEY"，"
" NEXT_YEAR_SESSION_SKEY"来自dbo。D_H_Session_By_SessQtr

// Connection: 3-Staging

CREATE TABLE "dbo"."F_Registration_STD_Session"
(
"REGISTRATION_KEY" VARCHAR(41) NULL,
"STUDENT_ID" VARCHAR(20) NULL,
"SESSION_ID" VARCHAR(20) NULL,
"LOAD_DT" DATETIME NULL,
"CLASS_ADD_COUNT" INTEGER NULL,
"CLASS_DROP_COUNT" INTEGER NULL,
"BEFORE_D0_CLASS_COUNT" INTEGER NULL,
"DAY0_CLASS_COUNT" INTEGER NULL,
"AFTER_D0_CLASS_COUNT" INTEGER NULL,
"ALL_CLASS_COUNT" INTEGER NULL,
"BEFORE_D0_ONLINE_CLASS_COUNT" INTEGER NULL,
"DAY0_ONLINE_CLASS_COUNT" INTEGER NULL,
"AFTER_D0_ONLINE_CLASS_COUNT" INTEGER NULL,
"ALL_ONLINE_CLASS_COUNT" INTEGER NULL,
"CLASS_NOSHOW_COUNT" INTEGER NULL,
"CLASS_WITHDRAW_COUNT" INTEGER NULL,
"COMPLETE_WITHDRAW_COUNT" INTEGER NULL,
"COMPLETE_NOSHOW_COUNT" INTEGER NULL,
"STUDENT_WITHDRAW_COUNT" INTEGER NULL,
"BEFORE_D0_ONLINE_ONLY_CLASS_CNT" INTEGER NULL,
"DAY0_ONLINE_ONLY_CLASS_COUNT" INTEGER NULL,
"AFTER_D0_ONLINE_ONLY_CLASS_COUNT" INTEGER NULL,
"ALL_ONLINE_ONLY_CLASS_COUNT" INTEGER NULL,
"SESSION_SKEY" INTEGER NULL,
"NEXT_REGISTERED_SESSION_SKEY" INTEGER NULL,
"PREV_REGISTERED_SESSION_SKEY" INTEGER NULL,
"SESSIONS_SKIPPED_NEXT" INTEGER NULL,
"SESSIONS_SKIPPED_PREV" INTEGER NULL,
"CLASS_ADD_DT" DATETIME NULL,
"CLASS_DROP_DT" DATETIME NULL,
"STUDENT_SKEY" INTEGER NULL,
"PREVIOUS_YEAR_SESSION_ID" VARCHAR(10) NULL,
"NEXT_YEAR_SESSION_ID" VARCHAR(10) NULL,
"CAMPUS_SKEY" INTEGER NULL,
"ACTIVITY_DT" DATETIME NULL,
"CAMPUS_ID" VARCHAR(2) NULL
)

CREATE INDEX ix1F_Registration_STD_Session ON
"dbo"."F_Registration_STD_Session" ( "STUDENT_ID" );
CREATE INDEX ix2F_Registration_STD_Session ON
"dbo"."F_Registration_STD_Session" ( "SESSION_ID" );
CREATE INDEX ix3F_Registration_STD_Session ON
"dbo"."F_Registration_STD_Session" ( "NEXT_REGISTERED_SESSION_SKEY" );
CREATE INDEX ix4F_Registration_STD_Session ON
"dbo"."F_Registration_STD_Session" ( "PREV_REGISTERED_SESSION_SKEY" );
CREATE INDEX ix5F_Registration_STD_Session ON
"dbo"."F_Registration_STD_Session" ( "STUDENT_SKEY" );
CREATE INDEX ix6F_Registration_STD_Session ON
"dbo"."F_Registration_STD_Session" ( "PREVIOUS_YEAR_SESSION_ID" );
CREATE INDEX ix7F_Registration_STD_Session ON
"dbo"."F_Registration_STD_Session" ( "NEXT_YEAR_SESSION_ID" );
CREATE INDEX ix8F_Registration_STD_Session ON
"dbo"."F_Registration_STD_Session" ( "CAMPUS_SKEY" );
CREATE INDEX STUDENT_ID ON "dbo"."F_Registration_Session_Lookup" (
"STUDENT_ID" );
CREATE INDEX SESSION_ID ON "dbo"."F_Registration_Session_Lookup" (
"SESSION_ID" )

CREATE TABLE "dbo"."D_H_Session_By_SessQtr"
(
"SESSION_SKEY" INTEGER NULL,
"SESSION_CAPTION" VARCHAR(19) NULL,
"SESSION_ID" VARCHAR(20) NULL,
"SESSION_YEAR" VARCHAR(20) NULL,
"SESSION_START_DT" DATETIME NULL,
"SESSION_END_DT" DATETIME NULL,
"SESSION_AddDrop_DT" DATETIME NULL,
"SESSION_DROP_DT" DATETIME NULL,
"SESSION_PNOTE_DUE1_DT" DATETIME NULL,
"SESSION_PNOTE_DUE2_DT" DATETIME NULL,
"SESSION_PNOTE_DUE3_DT" DATETIME NULL,
"SESSION_QTR" VARCHAR(20) NULL,
"SESSION_QTR_CAPTION" VARCHAR(23) NULL,
"All_id" VARCHAR(3) NULL,
"All_caption" VARCHAR(21) NULL,
"SESSION_ID_CAPTION" VARCHAR(50) NULL,
"PREVIOUS_SESSION_ID" VARCHAR(10) NULL,
"NEXT_SESSION_ID" VARCHAR(10) NULL,
"PREVIOUS_SESSION_SKEY" NUMERIC(19) NULL,
"NEXT_SESSION_SKEY" NUMERIC(19) NULL,
"PREVIOUS_YEAR_SESSION_ID" VARCHAR(10) NULL,
"NEXT_YEAR_SESSION_ID" VARCHAR(10) NULL,
"PREVIOUS_YEAR_SESSION_SKEY" NUMERIC(19) NULL,
"NEXT_YEAR_SESSION_SKEY" NUMERIC(19) NULL
)
;
CREATE INDEX ix1D_H_Session_By_SessQtr ON
"dbo"."D_H_Session_By_SessQtr" ( "SESSION_SKEY" );
CREATE INDEX ix2D_H_Session_By_SessQtr ON
"dbo"."D_H_Session_By_SessQtr" ( "SESSION_QTR" );
CREATE INDEX ix3D_H_Session_By_SessQtr ON
"dbo"."D_H_Session_By_SessQtr" ( "All_id" );
CREATE INDEX PREVIOUS_YEAR_SESSION_ID ON
"dbo"."D_H_Session_By_SessQtr" ( "PREVIOUS_YEAR_SESSION_ID" );
CREATE INDEX NEXT_YEAR_SESSION_ID ON "dbo"."D_H_Session_By_SessQtr" (
"NEXT_YEAR_SESSION_ID" )

[EXECUTEDSQ - 07:23:54] data insert

insert into "dbo"."F_Registration_STD_Session" ("REGISTRATION_KEY",
"STUDENT_ID", "SESSION_ID", "LOAD_DT", "CLASS_ADD_COUNT",
"CLASS_DROP_COUNT", "BEFORE_D0_CLASS_COUNT", "DAY0_CLASS_COUNT",
"AFTER_D0_CLASS_COUNT", "ALL_CLASS_COUNT",
"BEFORE_D0_ONLINE_CLASS_COUNT", "DAY0_ONLINE_CLASS_COUNT",
"AFTER_D0_ONLINE_CLASS_COUNT", "ALL_ONLINE_CLASS_COUNT",
"CLASS_NOSHOW_COUNT", "CLASS_WITHDRAW_COUNT",
"COMPLETE_WITHDRAW_COUNT", "COMPLETE_NOSHOW_COUNT",
"STUDENT_WITHDRAW_COUNT", "BEFORE_D0_ONLINE_ONLY_CLASS_CNT",
"DAY0_ONLINE_ONLY_CLASS_COUNT", "AFTER_D0_ONLINE_ONLY_CLASS_COUNT",
"ALL_ONLINE_ONLY_CLASS_COUNT", "SESSION_SKEY",
"NEXT_REGISTERED_SESSION_SKEY", "PREV_REGISTERED_SESSION_SKEY",
"SESSIONS_SKIPPED_NEXT", "SESSIONS_SKIPPED_PREV", "CLASS_ADD_DT",
"CLASS_DROP_DT", "STUDENT_SKEY", "PREVIOUS_YEAR_SESSION_ID",
"NEXT_YEAR_SESSION_ID", "CAMPUS_SKEY", "ACTIVITY_DT", "CAMPUS_ID")
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[EXECUTEDSQ - 07:26:20] checking existing Dimension table rows

select "SESSION_SKEY", "SESSION_CAPTION", "SESSION_ID",
"SESSION_YEAR", "SESSION_START_DT", "SESSION_END_DT",
"SESSION_AddDrop_DT", "SESSION_DROP_DT", "SESSION_PNOTE_DUE1_DT",
"SESSION_PNOTE_DUE2_DT", "SESSION_PNOTE_DUE3_DT", "SESSION_QTR",
"SESSION_QTR_CAPTION", "All_id", "All_caption", "SESSION_ID_CAPTION",
"PREVIOUS_SESSION_ID", "NEXT_SESSION_ID", "PREVIOUS_SESSION_SKEY",
"NEXT_SESSION_SKEY", "PREVIOUS_YEAR_SESSION_ID",
"NEXT_YEAR_SESSION_ID", "PREVIOUS_YEAR_SESSION_SKEY",
"NEXT_YEAR_SESSION_SKEY" from "dbo"."D_H_Session_By_SessQtr"

这篇关于慢sql更新MS SQL 2000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！