Index in WareHouse ?

Posted in 2000

Korn — 17 Jan 00 20:37:04 PST — source: Informix-list mailing list archive (1991-1998)

Hi Gurus, I need your opinions on putting an index in the warehouse and how it will affect the performance. Regards, Korn ____________________________________________________________________ Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com.

↪ replying to Korn

QueriX 4GL / Mehdi — Wed, 19 Jan 2000 13:39:49 +0000 — source: Informix-list mailing list archive (1991-1998)

Korn wrote: > Hi Gurus, > > I need your opinions on putting an index in the warehouse and how it will > affect the performance. > > Regards, > Korn > > ____________________________________________________________________ > Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com. Be more specific, it would depend much on the way the database is set up. The sort of information most often required, on which tables you should place indexes, etc...etc. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web) For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------