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,
70explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
IBM,
52how 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,
90Post New IBM Informix Questions
what is the size of informix page?
what are the database server operating modes available for informix? Explain each.
why do foreground writes decrease performance ?
what is informix universal server?
What are the informix isolation levels?
what are the options/commands used which dbspace a database resides?
what rules exist regarding format, content, flame wars, etc
Can you explain pdq priority?
what is a binary large object ?
who developed informix?
explain the concept of fragment elimination in informix ?
what is informix instance?
What is a database object in ibm informix?
what are the informix isolation levels and can you explain each one ?
why is update statistics important to a database?