ÓÎÏ×Á ÐÒÏ ÉÎÄÅËÓÙ

[Rodion]

ðÒÉ×ÅÔ ×ÓÅÍ !
IDS 9.21
íÏÖÎÏ ÌÉ ÐÏ ÓÏÏÂÝÅÎÉÀ oncheck:

ERROR:No btree item exists for data row.
Fragid 0xa00040 Rowid 0x8e8610 contains key value:
Key: 1093:2147:

ÐÏÌÕÞÉÔØ ËÏÎËÒÅÔÎÕÀ ÚÁÐÉÓØ , ÄÌÑ ËÏÔÏÒÏÊ ÎÅ ÓÕÝÅÓÔ×ÕÅÔ btree item ?
þÔÏÂÙ, ÎÁÐÒÉÍÅÒ, ÐÏÎÑÔØ, × ËÁËÏÅ ×ÒÅÍÑ ÐÏÄÐÏÒÔÉÌÓÑ ÉÎÄÅËÓ.





--
Best Regards,
Rodion Y. Musin

[Igor Zaiets]

äÙË ×ÙÄÁÌÏ:
Fragid 0xa00040 Rowid 0x8e8610
ðÅÒÅ×ÅÄÉ × ÄÅÓÑÔÉÞÎÙÊ É ÓÄÅÌÁÊ ÚÁÐÒÏÓ:
select --+FULL(...)
....
where
rowid = 9340432
äÉÒÅËÔÉ×Á - ÞÔÏÂÙ ÎÅ ÉÓÐÏÌØÚÏ×ÁÌÓÑ ÂÉÔÙÊ ÉÎÄÅËÓ.

Post by Rodion
ðÒÉ×ÅÔ ×ÓÅÍ !
IDS 9.21
ERROR:No btree item exists for data row.
ÐÏÌÕÞÉÔØ ËÏÎËÒÅÔÎÕÀ ÚÁÐÉÓØ , ÄÌÑ ËÏÔÏÒÏÊ ÎÅ ÓÕÝÅÓÔ×ÕÅÔ btree item ?
þÔÏÂÙ, ÎÁÐÒÉÍÅÒ, ÐÏÎÑÔØ, × ËÁËÏÅ ×ÒÅÍÑ ÐÏÄÐÏÒÔÉÌÓÑ ÉÎÄÅËÓ.
--
Best Regards,
Rodion Y. Musin

[Rodion]

äÅÌÏ × ÔÏÍ, ÞÔÏ rowid ÎÅÔ ÄÌÑ ÜÔÏÊ ÔÁÂÌÉÃÙ(ÓÈÅÍÁ ÎÉÖÅ).
ëÁË ÎÁÊÔÉ ÓÏÏÔ×ÅÔÓÔ×ÉÅ ÍÅÖÄÕ ÚÁÐÉÓÑÍÉ É rowid × ÜÔÏÍ ÓÌÕÞÁÅ?
(éÓÐÏÒÞÅÎÙÊ ÉÎÄÅËÓ - i_regss_kodka_ndog )

create table 'informix'.regss (
regssid SERIAL not null,
kodka INT not null,
ndog INT not null,
vrem DATETIME YEAR TO SECOND not null,
kodus INT not null,
nrm INT not null,
ft FLOAT not null,
fv FLOAT not null,
sumrez FLOAT not null,
sumok FLOAT not null,
prakt CHAR(1) not null,
cena FLOAT not null,
sumsk FLOAT not null,
key SMALLINT not null,
usrl CHAR(1),
vremr DATETIME YEAR TO SECOND,
ftmld FLOAT default 0.0000000000000000,
ftarax FLOAT default 0.0000000000000000
)
fragment by round robin in bill_dbs2,bill_dbs1,bill_dbs
extent size 16 next size 16
lock mode page;
create index 'informix'.i_regss on 'informix'.regss
(
kodka,
ndog,
kodus,
nrm,
vremr
);
create index 'informix'.i_regss_kodka_ndog on 'informix'.regss
(
kodka,
ndog
);
create index 'informix'.i_regss_vrem on 'informix'.regss
(
vrem
);
create index 'informix'.prakt_regss on 'informix'.regss
(
kodka,
ndog,
prakt
);
alter table 'informix'.regss add constraint primary key
(regssid)
constraint u123_127;

Post by Rodion
Fragid 0xa00040 Rowid 0x8e8610
select --+FULL(...)
....
where
rowid = 9340432
äÉÒÅËÔÉ×Á - ÞÔÏÂÙ ÎÅ ÉÓÐÏÌØÚÏ×ÁÌÓÑ ÂÉÔÙÊ ÉÎÄÅËÓ.

Post by Rodion
ðÒÉ×ÅÔ ×ÓÅÍ !
IDS 9.21
ERROR:No btree item exists for data row.
ÐÏÌÕÞÉÔØ ËÏÎËÒÅÔÎÕÀ ÚÁÐÉÓØ , ÄÌÑ ËÏÔÏÒÏÊ ÎÅ ÓÕÝÅÓÔ×ÕÅÔ btree item ?
þÔÏÂÙ, ÎÁÐÒÉÍÅÒ, ÐÏÎÑÔØ, × ËÁËÏÅ ×ÒÅÍÑ ÐÏÄÐÏÒÔÉÌÓÑ ÉÎÄÅËÓ.
--
Best Regards,
Rodion Y. Musin

[Igor Zaiets]

î-ÄÁ.
÷Ï ÆÒÁÇÍÅÎÔÉÒÏ×ÁÎÎÙÈ ÔÁÂÌÉÃÁÈ ÎÅÍÎÏÇÏ ÎÅ ÔÁË.
íÏÖÎÏ ÐÏÐÙÔÁÔØÓÑ ÅÝÅ ÔÁË:
unload to ...
select --+INDEX ....
ÐÏ ×ÙÇÒÕÖÅÎÎÏÍÕ ÆÁÊÌÕ ÏÐÒÅÄÅÌÉÔØ ËÁËÁÑ ÐÏÓÌÅÄÎÑÑ ÚÁÐÉÓØ ÂÙÌÁ É ÓÄÅÌÁÔØ
ÐÒÅÄÐÏÌÏÖÅÎÉÅ, ÞÔÏ ÓÌÅÄÕÀÝÁÑ ÎÅ ÐÏÐÁÌÁ × ÉÎÄÅËÓ.
ðÒÏ×ÅÒÉÔØ ÐÒÅÄÐÏÌÁÇÁÅÍÕÀ ÚÁÐÉÓØ ÐÏÓÌÅÄÏ×ÁÔÅÌØÎÙÍ ÓËÁÎÉÒÏ×ÁÎÉÅÍ É ÄÏÓÔÕÐÏÍ ÐÏ
ÉÎÄÅËÓÕ.
îÅ ÆÁËÔ, ÞÔÏ ×ÓÅ ÐÏÌÕÞÉÔÓÑ ÐÒÉ ÜÔÏÍ ÍÅÔÏÄÅ.

Post by Rodion
äÅÌÏ × ÔÏÍ, ÞÔÏ rowid ÎÅÔ ÄÌÑ ÜÔÏÊ ÔÁÂÌÉÃÙ(ÓÈÅÍÁ ÎÉÖÅ).
ëÁË ÎÁÊÔÉ ÓÏÏÔ×ÅÔÓÔ×ÉÅ ÍÅÖÄÕ ÚÁÐÉÓÑÍÉ É rowid × ÜÔÏÍ ÓÌÕÞÁÅ?
(éÓÐÏÒÞÅÎÙÊ ÉÎÄÅËÓ - i_regss_kodka_ndog )
create table 'informix'.regss (
regssid SERIAL not null,
kodka INT not null,
ndog INT not null,
vrem DATETIME YEAR TO SECOND not null,
kodus INT not null,
nrm INT not null,
ft FLOAT not null,
fv FLOAT not null,
sumrez FLOAT not null,
sumok FLOAT not null,
prakt CHAR(1) not null,
cena FLOAT not null,
sumsk FLOAT not null,
key SMALLINT not null,
usrl CHAR(1),
vremr DATETIME YEAR TO SECOND,
ftmld FLOAT default 0.0000000000000000,
ftarax FLOAT default 0.0000000000000000
)
fragment by round robin in bill_dbs2,bill_dbs1,bill_dbs
extent size 16 next size 16
lock mode page;
create index 'informix'.i_regss on 'informix'.regss
(
kodka,
ndog,
kodus,
nrm,
vremr
);
create index 'informix'.i_regss_kodka_ndog on 'informix'.regss
(
kodka,
ndog
);
create index 'informix'.i_regss_vrem on 'informix'.regss
(
vrem
);
create index 'informix'.prakt_regss on 'informix'.regss
(
kodka,
ndog,
prakt
);
alter table 'informix'.regss add constraint primary key
(regssid)
constraint u123_127;

Post by Rodion
Fragid 0xa00040 Rowid 0x8e8610
select --+FULL(...)
....
where
rowid = 9340432
äÉÒÅËÔÉ×Á - ÞÔÏÂÙ ÎÅ ÉÓÐÏÌØÚÏ×ÁÌÓÑ ÂÉÔÙÊ ÉÎÄÅËÓ.

Post by Rodion
ðÒÉ×ÅÔ ×ÓÅÍ !
IDS 9.21
ERROR:No btree item exists for data row.
ÐÏÌÕÞÉÔØ ËÏÎËÒÅÔÎÕÀ ÚÁÐÉÓØ , ÄÌÑ ËÏÔÏÒÏÊ ÎÅ ÓÕÝÅÓÔ×ÕÅÔ btree item ?
þÔÏÂÙ, ÎÁÐÒÉÍÅÒ, ÐÏÎÑÔØ, × ËÁËÏÅ ×ÒÅÍÑ ÐÏÄÐÏÒÔÉÌÓÑ ÉÎÄÅËÓ.
--
Best Regards,
Rodion Y. Musin