| Subject | SV: [firebird-support] select fieldA >= xxx is very very slow on Big table ? |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2010-12-20T09:41Z |
>> 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 ...
Set