Re: statistics on column access

From: chrisoc@ans.net > >I'm new to Informix but familiar with a couple other >database products. I've encountered a table in >a legacy database which has over 100 columns. >I've a hunch many of those are never accessed in >any SQL. How can I examine the stats? That would >be more efficient than reading mountains of source >code and even if I did I might miss an adhoc >query. Informix doesn't track any statistics by default. You'd have to install something like I-Spy or onprobe (which may imply performance issues) and even then, it would not be able to tell you what went on before you tried these tools. However, you can use grep and awk to automate your trawl through mountains of source code... :-) HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com