What is the use of extent in informix?
Answer / Ram Pravesh Sahni
In Informix, an extent is a logical unit used for space allocation. It is a grouping mechanism used to allocate space more efficiently and improve database performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain about informix 4gl.
what is a binary large object ?
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?
explain about light scans in informix?
what is informix universal server?
explain the purpose of optimizer directives and how/why you would use them
why is update statistics important to a database?
what command would you use to move the physical log?
what can be used to capture an isam error from an informix odbc program on unix?
Name the sql joins that are available in informix.
what is informix instance?
why a foreground write in informix decrease performance?state the reason for the same?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)