Antw: order by
Hi,
do it like this:
SELECT * FROM seosed
WHERE onimi MATCHES "*LIISING*"
into temp result;
SELECT * FROM result
where onimi >=""
ORDER BY onimi
Martin
>>> =?windows-1257?B?VmxhZGltaXIgUvxudPw=?= <vlads@kredinfo.ee> 09.08.00 13:21 >>>
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