Re: query performance

Table and/or index fragmentation? Does one have attached indexes and the other one detached? (Attached indexes will show up in the output from dbschema -ss with the "IN TABLE" clause). Are the tables/indexes locatedon different disk structures that may either be configured differently under the hood or experiencing different levels of load from external sources? Did you use the FORCE option when you updated statistics? If you run the query with SET EXPLAIN are the query plans different? How? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Feb 5, 2013 at 10:55 AM, Laurie Gustin <lgustin@utah.gov> wrote: > I have two databases that appear to be identical on the same server. The > data is only slightly different. I run the same query on both databases > and on one it finishes in 2 seconds... the other takes over 4 hours. I > have rebuilt indexes, and updated statistics but nothing seems to help. > Is there anything else I can look at to see why the difference in > performance? > > Thanks > Laurie > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >