Re: Indexing strategy

The way that I sorted this out is to run "isql - -" and enter the command "set explain on" then in another window/terminal I type "tail -f ~/sqlexplain.out" (I couldn't swear that the spelling is right) I then add and drop indexes and do a few simple selects and informix says how it is doing the searches. A tip - don't worry when you see the estimated cost of an "update where current of" - they don't mean anything - just ignore them. I noted that Online makes much better use of indexes than older versions which wanted the fields in the where clause to be in the same order as in the index. Nick Hounsome AT&T NS Uk