RE: Index utilization

Posted in 2005

Dirk Moolman — Thu, 15 Sep 2005 13:30:05 +0200 — source: Usenet: comp.databases.informix

-----Original Message----- From: Malcolm Perrior [mailto:malc_p@btinternet.com] Sent: 15 September 2005 01:09 PM --- Dirk Moolman <DirkM@caretech.co.za> wrote: > I would like to see, looking at an entire instance, > which INDEXES are > being used, and which aren't. > > Is there a tool that can show / analyse this for me > ? > > > PS. I am still running on IDS 7.31 FD3 ---- >Only if the indexes are detached - then you can use >something like: > >database mydb; >select i.idxname, p.bufreads, p.bufwrites >from sysindexes i, sysmaster:sysptprof p >where i.idxname = p.tabname >order by 2 desc # or whatever you prefer here Most of mine are still attached. It is a pity actually. My company is busy moving from Informix to Oracle, and every now and then I hear about the great tools Oracle has - eg. analysing it queries, and even suggesting new indexes etc. sending to informix-list