论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-12-07 16:31 |只看该作者 |倒序浏览

我对表table_name进行更改,发现在pb里改不了,在unix中用语句改速度特慢.

在pb里面改出现:
Row changed between retrieve and update.

No changes made to database.

DELETE FROM table_name WHERE xxno = '49780066102000133' AND appinfo = '000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' AND serialno = '0000002793998949' AND attr = '9' AND custnm IS NULL AND abbrnm = '?￡è?D?' AND sex = 'f' AND idty = '0' AND idcd = '000350111781204048' AND fmyzip IS NULL AND fmyaddr IS NULL AND fmyph = '13706961779' AND cozip IS NULL AND coaddr IS NULL AND coph = '' AND fax IS NULL AND cont = '' AND annualfee = '' AND openope = '1' AND issueope = 'Kj' AND status = 'n' AND accountid = '000000000000000000' AND pincounter = 0 AND integralflag = '0' AND branchid = '1002' AND nodeid = '000' AND internalflag = '0'

文库|博客

acb

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2004-12-07 16:52 |只看该作者

表update很慢,请教高手?

用sp_help table_name察看如下:

Name                         Owner
   Type
------------------------------ ------------------------------
----------------------
table_name                      dbo
   user table

(1 row affected)
Data_located_on_segment       When_created
------------------------------ --------------------------
default                            May 24 2002  2:06PM
Column_name                   Type                         Length Prec
   Scale Nulls Default_name
   Rule_name                   Identity
------------------------------ ------------------------------ ------ ----
----- ----- ------------------------------
------------------------------ --------
xxno                      char                            18 NULL
   NULL    0 NULL
   NULL                               0
appinfo                      char                            100 NULL
   NULL    1 NULL
   NULL                               0
serialno                      char                            16 NULL
   NULL    1 NULL
   NULL                               0
attr                         char                               1 NULL
   NULL    0 NULL
   NULL                               0
custnm                      varchar                         40 NULL
   NULL    1 NULL
   NULL                               0
abbrnm                      char                            10 NULL
   NULL    1 NULL
   NULL                               0
sex                         char                               1 NULL
   NULL    1 NULL
   NULL                               0
idty                         char                               2 NULL
   NULL    1 NULL
   NULL                               0
idcd                         char                            20 NULL
   NULL    1 NULL
   NULL                               0
fmyzip                      char                               6 NULL
   NULL    1 NULL
   NULL                               0
fmyaddr                      varchar                         40 NULL
   NULL    1 NULL
   NULL                               0
fmyph                         varchar                         30 NULL
   NULL    1 NULL
   NULL                               0
cozip                         char                               6 NULL
   NULL    1 NULL
   NULL                               0
coaddr                      varchar                         40 NULL
   NULL    1 NULL
   NULL                               0
coph                         varchar                         20 NULL
   NULL    1 NULL
   NULL                               0
fax                         char                            20 NULL
   NULL    1 NULL
   NULL                               0
cont                         char                            20 NULL
   NULL    1 NULL
   NULL                               0
expiredate                   datetime                         8 NULL
   NULL    1 NULL
   NULL                               0
annualfee                   char                               1 NULL
   NULL    1 NULL
   NULL                               0
openope                      char                               6 NULL
   NULL    1 NULL
   NULL                               0
opendate                      datetime                         8 NULL
   NULL    1 NULL
   NULL                               0
issueope                      char                               6 NULL
   NULL    1 NULL
   NULL                               0
issuedate                   datetime                         8 NULL
   NULL    1 NULL
   NULL                               0
status                      char                               1 NULL
   NULL    1 NULL
   NULL                               0
accountid                   char                            18 NULL
   NULL    1 NULL
   NULL                               0
pincounter                   smallint                         2 NULL
   NULL    0 ic_card_pincou_1536008503
   NULL                               0
integralflag                char                               1 NULL
   NULL    0 ic_card_integr_1552008560
   NULL                               0
branchid                      char                               4 NULL
   NULL    1 NULL
   NULL                               0
nodeid                      char                               3 NULL
   NULL    1 NULL
   NULL                               0
internalflag                char                               1 NULL
   NULL    0 ic_card_intern_1568008617
   NULL                               0
index_name          index_description
   index_keys
   index_max_rows_per_page index_fillfactor index_reservepagegap
-------------------- --------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------- ---------------- --------------------
pk_table_name          clustered, unique located on default
   xxno
                        0             0                   0

(1 row affected)
No defined keys for this object.
Object is not partitioned.
Lock scheme Allpages
The attribute 'exp_row_size' is not applicable to tables with allpages lock
scheme.
The attribute 'concurrency_opt_threshold' is not applicable to tables with
allpages lock scheme.

exp_row_size reservepagegap fillfactor max_rows_per_page identity_gap
------------ -------------- ---------- ----------------- ------------
         0             0       0                0          0

(1 row affected)
concurrency_opt_threshold
-------------------------
                     0
(return status = 0)