RE: order by
- Create an index on the field onimi
- Run update statistics
- Try it with the Like command where onimi like '%LIISING%'
Regards,
Franky
-----Oorspronkelijk bericht-----
Van: Vladimir R'nt' [mailto:vlads@kredinfo.ee]
Verzonden: woensdag 9 augustus 2000 13:21
Aan: informix-list@iiug.org
Onderwerp: order by
Hello!
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?
best wishes,
Vlads