An index is reaching a limitation on the number of pages it has, can you explain why this limitation exists and what work you would do to get around it?
IBM,
56explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
IBM,
50how would you check that a given index is consistent and has no corruption? If corruption occurred on a database what would your process be?
IBM,
83Post New IBM Informix Questions
what is extent in informix?
What is the use of extent in informix?
why do foreground writes decrease performance ?
what command would you use to move the physical log?
why a foreground write in informix decrease performance?state the reason for the same?
explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
can I install informix on a non-english version of windows nt?
I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?
why is update statistics important to a database?
List down the features of informix 4gl.
what are the sql joins available in informix?
What is a light scan in informix?
Name the sql joins that are available in informix.
what are the uses of key value locking in informix?
how would you convert a secondary server into a primary server ?