Subject | Re: Index makes select very slooooow! |
---|---|
Author | karlzeift |
Post date | 2004-02-25T14:36:14Z |
I'm not really sure what you mean, but I think it's the "Selectivity"
you are thinking about... is that correct?
IX_ENTITY_CUSTOMER: 38.88
IX_UNIFIEDMESSAGE_BOLD_TYPE: 4147.5
IX_UNIFIEDMESSAGE_ENTITY: 15.74
I'm using PLANalazyer to get these values.
Karl
--- In firebird-support@yahoogroups.com, "Svein Erling"
<svein.erling.tysvaer@k...> wrote:
you are thinking about... is that correct?
IX_ENTITY_CUSTOMER: 38.88
IX_UNIFIEDMESSAGE_BOLD_TYPE: 4147.5
IX_UNIFIEDMESSAGE_ENTITY: 15.74
I'm using PLANalazyer to get these values.
Karl
--- In firebird-support@yahoogroups.com, "Svein Erling"
<svein.erling.tysvaer@k...> wrote:
> What are the index statistics foreach
>
> IX_ENTITY_CUSTOMER, IX_UNIFIEDMESSAGE_BOLD_TYPE and
> IX_UNIFIEDMESSAGE_ENTITY? And approximately how many records have
> of the values specified in your where clause?
>
> Set