informix views

here is the question: how informix (ON-LINE) processes queries involving views? it seems to me that it first materializes the view and than executes selections... it would be much better to perform string substitution first and than materialize the view using only a subset of the rows that belong to the base tables. anybody knows the details? does it depend on how the engine is installed? if there is no way to apply selection to the base tables first it is really depressing! good waverals to everybody. gigi. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ----------------- ----------- Luigi Suardi -|-------------- / | Software Interfaces, Inc. -|-|----------- | ----- | 1400 Broadfield -|-|-|-------- \\ \\ | | Houston, TX 77084 -|-|-|-|----- \\ \\ | | | | | | | \\ \\| | | | | | | ----- | email: gigi@softint.com | | | | | | /| | tel : (713)4920707 ------- --- fax : (713)4920725 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~