views and update statistics

hi all how can one see the last time statistics were update for a view? or does it just relate back to when the tables within the view were last updated? thanks much -

There is no pre-calculated query plan for a VIEW nor are there any statistics associated with the view itself. You just have to maintain the stats for the underlying table(s). Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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 Wed, Jan 20, 2010 at 9:29 AM, Tom Lehr <tomcaml@gmail.com> wrote: > hi all > > how can one see the last time statistics were update for a view? > or does it just relate back to when the tables within the view were > last updated? > thanks much - > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >