Informix Question:
Download Questions PDF

Explain about light scans in Informix?


Light scans occur under the following conditions: The optimizer chooses a sequential scan of the table. The number of pages in the table is greater than the number of buffers in the buffer pool. The isolation level obtains no lock or a shared lock on the table: Dirty Read (including non logging databases) isolation level Repeatable Read isolation level if the table has a shared or exclusive lock
Committed Read isolation if the table has a shared lock

Download Informix Interview Questions And Answers PDF

Previous QuestionNext Question
Mention the database server operating modes available for Informix?What is extent in Informix?