unused indexes (Informix 7.31)

Posted in 2008

revilofe — Tue, 27 May 2008 07:15:14 -0700 (PDT) — source: Usenet: comp.databases.informix

Hi everybody how do I know which index is used on a table when the program execute? I want to do a clean up of unused indexes and tables. Thanks. (informix 7.31)

↪ replying to revilofe

Kevin Cherkauer — Tue, 27 May 2008 10:19:10 -0700 — source: Usenet: comp.databases.informix

Check the manuals for the "SET EXPLAIN" statement. Here is a link for it in 11.10. (I hope this also exists in 7.31! I don't have a link to 7.31 manuals handy.) http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.sqls.doc/sqls813.htm -- Kevin Cherkauer Software Engineer IBM Informix Dynamic Server -- Database Kernel "revilofe" <revilofe@gmail.com> wrote in message news:e4c4d42c-1d24-464d-b191-f00a4be03d31@25g2000hsx.googlegroups.com... > Hi everybody > > how do I know which index is used on a table when the program execute? > I want to do a clean up of unused indexes and tables. > > Thanks. > > (informix 7.31) >