Subject select fieldA >= xxx is very very slow on Big table ?
Author Vander Clock Stephane
Hello,

why this simple sentence :

Select
First 1 skip 0 ID
from
TABLEA
where
FIELDA >= xxx
PLAN (TABLEA INDEX (FIELDA_IDX))

is very slow on big table (> 20 000 000 rows) ... it's take more than 10
seconds to return :(

this is an index on FIELDA

did i do something wrong ?

thanks you by advance
st├ęphane