Determining unused tables

How can I know when was the last time a table was accessed for select, insert, update or delete records? -- Gerardo Santana

Gerardo Santana wrote: > How can I know when was the last time a table was accessed for select, > insert, update or delete records? > > -- > Gerardo Santana > AFAIK the engine doesn't save this anywhere... And it wouldn't make much sense to do it IMHO. You have several options, but it will depend on what you need: 1- There are triggers for all this, although the SELECT trigger has several limitations 2- You can define a single trigger for several tables if you're using v10+ There were changes in the Datablade API that allow us to find which table triggered the event. You can probably find more info if you search for Jacques Roy. He wronte an article on this 3- You have the audit mnemonic ACTB. I don't recal exactly what it does or doesn't do, but IIRC it will appear whenever a table is reference in several situations. I can probably find more info about this because I asked for a new feature related to this... I just don't recall the details at the moment Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

Gerardo Santana wrote: > How can I know when was the last time a table was accessed for select, > insert, update or delete records? > > -- > Gerardo Santana > You can turn on auditing.