explain about light scans in informix?
Answer / Rajneesh Choudhary
Light Scans in IBM Informix is a technique used for efficient data retrieval. When a query requests only a small percentage of the total records, Light Scan allows the server to quickly locate and return the required data by accessing only the relevant index pages instead of scanning all the tables or indexes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain about informix 4gl.
why a foreground write in informix decrease performance?state the reason for the same?
can I install informix on a non-english version of windows nt?
explain the concept of fragment elimination in informix ?
Name the sql joins that are available in informix.
how would you convert a secondary server into a primary server ?
What are the informix isolation levels?
Can you explain pdq priority?
explain the purpose of optimizer directives and how/why you would use them
what are the sql joins available in informix?
what is an informix instance?
why is update statistics important to a database?
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)