Hi,
IDS 10.0.fc5 on AIX 5.3.

Trying to tune a slow query. I think I got it boiled down to this:
The select is joining with a view, and that view is joining with another
view in it's create statement.
The inner view seems to cause a table scan.

I created an index, dropped and recreated that view and now I can get a
select from that view without an table scan.
But....
If I do a select from that view and join it to another table in the select,
no matter what I try, it creates a temporary table for the view and scans
it.

Is this something that can possibly be avoided ?

Thanks !
Floyd


--
Floyd Wellershaus
Dba/Sa Informix/Oracle/Linux/Aix

http://photos.fwellers.com
================================================== ======

Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file?

Regards,
Doug Lawry