| Subject | Re: [firebird-support] Re: View plan without executing query? |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-02-22T14:08:56Z |
At 02:27 PM 22/02/2005 +0100, you wrote:
set. SELECT * will use indexes if they are useful.
./hb
>Hi Adam,Hmm, no. SELECT COUNT always uses NATURAL, since it has to walk the
>
>Yes, I've been using "first 1" for that purpose on select queries. But
>it doesn't work for count(*) queries. On the other hand, perhaps the
>plan is the same for "select count(*)" and "select *"?
set. SELECT * will use indexes if they are useful.
./hb