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,
50explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
IBM,
42how 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,
81Post New IBM Informix Questions
who developed informix?
what is informix binary large object?
Can you explain pdq priority?
What is a database object in ibm informix?
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?
What is a light scan in informix?
what is extent in informix?
why is update statistics important to a database?
explain the purpose of optimizer directives and how/why you would use them
Explain about informix 4gl.
who conceived and designed the informix database management system?
how would you convert a secondary server into a primary server ?
why a foreground write in informix decrease performance?state the reason for the same?
what are the uses of key value locking in informix?
what are the informix isolation levels and can you explain each one ?