Re: INFORMIX SE

Posted in 1998

Art S. Kagel — Mon, 30 Nov 1998 13:05:59 -0500 — source: Informix-list mailing list archive (1991-1998)

Didier Festers wrote: > > Hi, > > I just finished to install Informix SE under my ReHat Linux box. It > works fine. > > But someone can help me to find informations on how to build a good > structured database under SE? > Is it better to make only one table in a database or can I construct a > lot table ? > How does works indexes? Have I only one Index or can I build a index for > each table? You can have as many tables and indexes as you want. SE supports up to 16 indexes on up to eight columns each for each table you create. The number of tables in a database is limited only by disk space and the number of open files your system will permit the SQLEXEC process to have access to. Art S. Kagel