unused indexes (Informix 7.31)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

revilofe - 27 May 2008 15:15 GMT

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)

Reply to this Message

Kevin Cherkauer - 27 May 2008 18:19 GMT

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.s
qls.doc/sqls813.htm

Signature

Kevin Cherkauer
Software Engineer
IBM Informix Dynamic Server -- Database Kernel

> Hi everybody
>
[quoted text clipped - 4 lines]
>
> (informix 7.31)

Reply to this Message