Hi,

Related to my above post, is it possible for data in the main memory
to refresh itself, when a change is made in the base tables.

Indexes:

1)Are indexes brought into main memory when DB is made online, or is
it fetched only when invoked?

2)What is possibly the life of an index in main memory?

Lookup Tables:

1) I want to keep a set of Lookup tables for my application. In
firebird, is there any definition for creating lookup tables which
can be held in main memory (< 3KB) ?