Index failure problem

Posted in 2000

Topics: Data Types & Schema Design, Triggers, Constraints & Referential Integrity

Roman Zarzecki — Mon, 13 Nov 2000 13:47:59 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi, I work on Informix 7.3 and sometimes I have problems with indexes that I have created by mysef, they where not created automaticly during the creation of foregin key or unique constraint. For example I have created index for nvarchar(20) column in the table to speed up the queries. For that index sometimes I have an index failure error in the IECC Console. I also use the indexes on tempopery tables and they sometimes cause this problem. I would like to know if I can avoid this. I create indexes like that: create index index_name on table_name(column); Regards, Roman Zarzecki rzarzecki@gis.com.pl

↪ replying to Roman Zarzecki

smooth1 — Mon, 13 Nov 2000 23:25:31 -0000 — source: Informix-list mailing list archive (1991-1998)

What is the 'index failure' error message? Roman Zarzecki wrote in message <8uons2$e46$1@news.ipartners.pl>... >Hi, > > I work on Informix 7.3 and sometimes I have problems with indexes that I >have created by mysef, they where not created automaticly during the >creation of foregin key or unique constraint. For example I have created >index for nvarchar(20) column in the table to speed up the queries. For that >index sometimes I have an index failure error in the IECC Console. I also >use the indexes on tempopery tables and they sometimes cause this problem. > I would like to know if I can avoid this. I create indexes like that: >create index index_name on table_name(column);> >Regards, >Roman Zarzecki >rzarzecki@gis.com.pl > > > >

↪ replying to Roman Zarzecki

Art S. Kagel — Mon, 13 Nov 2000 19:36:25 -0500 — source: Informix-list mailing list archive (1991-1998)

Is you database logged? I see this frequently with unlogged databases! Art S. Kagel Roman Zarzecki wrote: > > Hi, > > I work on Informix 7.3 and sometimes I have problems with indexes that I > have created by mysef, they where not created automaticly during the > creation of foregin key or unique constraint. For example I have created > index for nvarchar(20) column in the table to speed up the queries. For that > index sometimes I have an index failure error in the IECC Console. I also > use the indexes on tempopery tables and they sometimes cause this problem. > I would like to know if I can avoid this. I create indexes like that: > create index index_name on table_name(column);> > Regards, > Roman Zarzecki > rzarzecki@gis.com.pl