Off-topic here, Grumpy.

Please use the firebird-support list for support questions.

"Grumpy II" aka ^heLen (resident Witch)


At 02:39 AM 25/08/2004 +0000, GrumpyRain wrote:

>I am sure this would have been asked before. I did a search and
>couldn't find anything so apologies in advance if this has been answered.
>
>I have a select statement on a table with about 3000 records in it.
>There is a field which I need in my where clause that is a foreign key
>(so there is an implied index on it). I have also another index on the
>another field in the where clause.
>
>The foreign key field is a really poor choice (selectivity = 2500),
>whereas the other index is a good choice (selectivity = 25).
>
>Can I add something to the query to suggest the best query plan to use?
>
>
>
>
>Community email addresses:
> Post message: Firebird-general@yahoogroups.com
> Subscribe: Firebird-general-subscribe@yahoogroups.com
> Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
> List owner: Firebird-general-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/Firebird-general
>Yahoo! Groups Links
>
>
>
>