Subject how do i speed this up?
Author martinknappe
i have here the script of a database:

now, i've created the database and inserted some 200 000 random
entries in table 'dicentries'
when i execute the following query:

select first 1 id from dicentries where (asterm = '' and id > 0)
(asterm > '' and id > 0) order by asterm ascending, id ascending

it takes around 8 seconds to execute!
will i have to put up with this or does any of you see a way to speed
this up?

thanx very much,