Improves performance by eliminating the need to regenerate the query. Lets you optimize application workload and response time. Optimizes the working set of data that satisfies each query. Provides access to flexibility of the database engine. Ensures that all database rules and standards are enforced and that the full relational integrity of the database is maintained.
Informix users can easily move through data in both forward and backward searches.
It is a subset of one or more database tables. Facilitates program conversion and simplifies future changes to databases. Also provides control of user access to sensitive data. Dynamic file system switching Acu4GL for Informix allows you to use both the Informix and Acucorp Vision file systems at the same time. This is accomplished by changing the value of a configuration variable to indicate the data file type before opening a file.