Optimizer & Views

Hello Informixer who know about the optimizer! I have a problem with the performance when selecting through a view. The output of the SET EXPLAIN option shows that there is a temp table generated for the View I use. I assume that my performance problems come from this temp table. My question: 1.) When (under what circumstances) does Informix use a temp table for a view? 2.) If it does so, are the selection criteria in the query (the WHERE clause) already applied to the temp table? We're using Online 5.01 on Solaris. Thanks in advance. Achim -- ========================================================================== / Achim Reiners Software Engineering \\ | /M/A/I Deutschland GmbH | | Softwarezentrum Koeln Phone: +49 221 956400-40 | | Mathias-Brueggen-Str. 85 Fax: +49 221 956400-69 | \\ 50829 Koeln E-Mail: ar@mai.de / \\_________________________________________________________________________/