Re: Trouble with Sco Unix and Informix URGENT !!!!!!!!!!

You can check the query plan - just run before the query SET EXPLAIN ON. Then you can see the query plan in the file sqexplain.out. If it is not what you are expecting try running update statistics on table. And finally a stupid question: are you sure it is the "order by" that slows down the system ? Best Regards, Octav Arthur Gommel wrote: > > Thanks for your reply. > > The only information i have at the moment is that when we run a query with > an "order by" statement using indexed fields the system performance is > incredibly low. > Because these query's are very important to me i cant remove them. > > Hope to hear from u again > > Arthur > ----- > > Oorspronkelijk bericht----- > Van: Octav Chiriac <com@netinfo-moldova.com> > Aan: Arthur Gommel <argo.margo@wxs.nl>; informix-list@iiug.org > <informix-list@iiug.org> > Datum: dinsdag 21 september 1999 16:30 > Onderwerp: Re: Trouble with Sco Unix and Informix URGENT !!!!!!!!!! > > > > >Could you be more explicit? What is exactly the problem ? > > > >Best Regards, > >Octav > > > >Arthur Gommel wrote: > >> > >> Hi, > >> > >> im having trouble with sco unix and informix. The main trouble seems to > be > >> to order by command in a query. > >> Need some help fast. > >> if u do have an idea please inform me as soon as possible > >> > >> Many, many thanks in advance > > > >-- > >Octav Chiriac Phone: (373) 2 22 99 67 > >NetInfo S.R.L. Fax: (373) 2 21 36 59 > >Chisinau (373) 2 22 84 88 > >Moldova, Republic of mailto:com@netinfo-moldova.com -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com