set explain alternative

Posted in 1999

Bridget Reitsma — Wed, 04 Aug 1999 09:38:24 +1200 — source: Informix-list mailing list archive (1991-1998)

Hi Just a quick question - I want to find out which indexes are being used to access my tables and I would prefer not to use set explain. Is there any other way by which I can see which indexes are being used? thanks Bridget

↪ replying to Bridget Reitsma

Lucie Janstova — Wed, 4 Aug 1999 16:42:47 +0200 — source: Informix-list mailing list archive (1991-1998)

Only command "set explain..." has picture access to table ( in line-mode), but you can try graphic utility "onperf". Lucy Bridget Reitsma wrote in message <37A76150.FEC05F80@auckland.ac.nz>... >Hi > >Just a quick question - I want to find out which indexes are being used >to access my tables and I would prefer not to use set explain. Is there >any other way by which I can see which indexes are being used? > >thanks Bridget >