Re: order by

From: Vladimir R'nt' <vlads@kredinfo.ee> > >I have Informix Online 7.2 running on SCO OpenServer 5 > >Query > >SELECT * FROM seosed >WHERE onimi MATCHES "*LIISING*"> >takes about 3 seconds to complete. >and the resultset contains about 50 records. >Table seosed contains about 100 000 records > >but > >SELECT * FROM seosed >WHERE onimi MATCHES "*LIISING*" >ORDER BY onimi> >takes about 15 minutes. What should I do >to make this query complete quicker? UPDATE STATISTICS If that doesn't work, try SELECT * FROM seosed WHERE onimi MATCHES "*LIISING*" INTO TEMP pwatson; SELECT * FROM pwatson ORDER BY onimi; ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Obnoxio The Clown wrote in message <8mri2i$sa3$1@news.xmission.com>... > >From: Vladimir R'nt' <vlads@kredinfo.ee> >> >>I have Informix Online 7.2 running on SCO OpenServer 5 >> >>Query >> >>SELECT * FROM seosed >>WHERE onimi MATCHES "*LIISING*">> >>takes about 3 seconds to complete. >>and the resultset contains about 50 records. >>Table seosed contains about 100 000 records >> >>but >> >>SELECT * FROM seosed >>WHERE onimi MATCHES "*LIISING*" >>ORDER BY onimi>> >>takes about 15 minutes. What should I do >>to make this query complete quicker? > >UPDATE STATISTICS> >If that doesn't work, try > >SELECT * FROM seosed >WHERE onimi MATCHES "*LIISING*" >INTO TEMP pwatson WITH NO LOG; > >SELECT * FROM pwatson >ORDER BY onimi;> I've seen this as well recently on IDS Workgrup Edition 7.31.UC4-1 running on Solaris 2.5.1. Anyone have any ideas? >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >