question about Query with joined view

Posted in 2011

Topics: Performance & Tuning, SQL Development & Query Writing, Server Administration, Platform-Specific Issues, Versions, Editions & End-of-Life

Floyd Wellershaus — Thu, 3 Mar 2011 11:44:47 -0500 — source: Usenet: comp.databases.informix

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 ========================================================

↪ replying to Floyd Wellershaus

Doug Lawry — Fri, 4 Mar 2011 00:44:18 -0800 (PST) — source: Usenet: comp.databases.informix

Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file? Regards, Doug Lawry