Re: Guide to indexing tables

It's quite some time since I read those parts of the manuals, but as I remember it there is quite good information about creating indexes there. Particularly in the tutorials. Essentially you create unique indexes on every primary key, non unique on every foreign key and aditional indexes on other columns or combinations of collumns that may take part in a join. Then you analyze your sql and see if other indexes would be helpfull due to special where clauses or order by. Also make sure you set explain on and analyze the sqexplain.out file to find if additional indexes are needed. Some of the books mentioned in the book section on www.iiug.org probably have further information on this. John C. Musselman <john@primenet.com> wrote: :Is there a resource out there that provides guidelines for indexing :database tables? : :If if helps, I am working with a 4.0 Standard engine database. : :I could also provide more specific details about table columns and such, :but I am looking for a more detailed guide than the Informix manuals :provide. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org