Oninit cdi / Archive
Talk to an expert →

Poor view performance

Posted in 2006

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

Paul Watson — — source: Usenet: comp.databases.informix

Solaris 2.8 IDS 10.0.FC4 Simple view joining two tables (4M and 25M rows). One is the live table, the other the archive As a select/union the query is quick and uses all the 'proper' indexes. As a view it does a S-scan over the 25M table and I always got bored before it completed. Any ideas ? [Yes, stats are upto date] Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 European Conference. Vienna, Austria. 2-6 October 2006 Visit http://www.iiug.org/conf for more information.

↪ replying to Paul Watson
Doug Lawry — — source: Usenet: comp.databases.informix

Hi Paul. See other thread on IFX_FOLDVIEW. Cheers, Doug "Paul Watson" <paul@oninit.com> wrote in message news:064501c67f53$ad3bd330$0201a8c0@Arnold... > Solaris 2.8 IDS 10.0.FC4 > > Simple view joining two tables (4M and 25M rows). One is the live > table, the other the archive > > As a select/union the query is quick and uses all the 'proper' indexes. > As a view it does a S-scan over the 25M table and I always got bored > before it completed. > > Any ideas ? > > [Yes, stats are upto date] > > Paul Watson > Tel: +44 1414161772 > Mob: +44 7818003457 > > GO FURTHER with DB2 > GET THERE FASTER with Informix. > Attend the IDUG 2006 European Conference. > Vienna, Austria. 2-6 October 2006 > Visit http://www.iiug.org/conf for more information.

Glossary