| Subject | select fieldA >= xxx is very very slow on Big table ? |
|---|---|
| Author | Vander Clock Stephane |
| Post date | 2010-12-19T20:08:31Z |
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
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