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,
90explain checkpoints and why in 9.4 they were better than in previous versions of the engine?
IBM,
64how 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,
106Post New IBM Informix Questions
why is update statistics important to a database?
what is an extent in informix?
what is the option or command used in informix for finding which dbspace a database resides?
somehow informix fails to go online. Is there a way to view what oninit is doing?
Explain about informix 4gl.
what is informix binary large object?
mention the database server operating modes available for informix?
explain the concept of fragment elimination in informix ?
I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?
what is a binary large object ?
what is informix universal server?
explain the purpose of optimizer directives and how/why you would use them
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?
why do foreground writes decrease performance ?
Explain the informix instance.