Re: Last time update stats ran

Look in the sysdistrib table. There is a column called constructed that contains the date. You will need to look up the tabid for your table first by running select tabid from systables where tabname = "x"; Then do select * from sysdistrib where tabid = n; Dianne ______________________________ Reply Separator _________________________________ Subject: Last time update stats ran Author: "Carl Gruber" <cmgruber@americanstates.com> at INTERNET Date: 9/4/97 6:54 PM His everyone! Is there an easy way to tell when the last time an "update stats" ran for a particular table? Thanks for any help. Carl ODS V7.23 -- Carl Gruber (cmgruber@americanstates.com) Informix ODS V7.23 Metacube front end