Re: What data access methods Informix have ?

I was a DBA for Ingres for three years. Yes, it was nice to have the choice of the four methods, but for the *most* part, indexes were built as btree. Informix builds b+tree indexes only, so you're not missing much. ------------------------------------------------------------------------- Herb Blacker Cimarron, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Fri, 17 Oct 1997, Jiang Lu wrote: } Hi, there, } } In Ingres, for each table, it may be exist in four types of data orgnisations, } their heap, hash, isam, btree. In addition, indexes can be created for other } attributes as one of these four types. } } I am reading an Informix book now. it does not address this issue very clearly. } } can any one tell me : } } what type data orgnisations Informix can have ? } what indexing methods could be build for each table ? } } Thanks. } } Jiang }