|Subject||SV: [firebird-support] select fieldA >= xxx is very very slow on Big table ?|
|Author||Svein Erling Tysvær|
>> If you are simply looking to confirm that *any* row exists, then theWHAT! Both selecting from RDB$DATABASE and EXISTS should normally be very fast. Tell us more (PLAN of this query and the '= 487' query), Stephane, and rerun the RDB$DATABASE query to verify your findings.
>> following SQL is more appropriate/faster to use:
>> SELECT 1 From RDB$Database where EXISTS(Select 1 from TABLEA where
>> FIELDA >= xxx)
>i just launch this query 7 min ago, i m still waiting the answer :( not
>very fast ...