Re: Performance hit with large number of rows and compound index

> > A client of ours has standard Informix 5.02 installed as part of a turn-key > > system from a third party, and is experiencing a bad performance hit > > on a table with a compound index, which has grown to over 30,000 rows. > > > > They have heard a rumour that this is a known problem. Can anyone shed any > > light? > > --------------------------------------------------------- > > Chris Palmer > > Deloitte Touche Tohmatsu, Auckland, New Zealand > > c.palmer@dtt.co.nz > It may be a bug. What is the platform? I ran into a bug with the SE not using the proper index when that index was large (multiple columns). It also did not show up until I did a "update statistics"!! Try doing a "set explain on" and double check the results with what you would expect the engine to be doing. My versions: SCO Unix ver 3.2v4.2 Informix SE ver 5.01.UD3 Informix ISQL ver 4.11.UC4 -- ============================================================================== John R. Morris | email: jrm@hycel.com Director of Data Processing | phone: (314) 961-2000 fax: (314) 961-8508 ==============================================================================