Subject | Re: [firebird-support] Re: Index Selectivity |
---|---|
Author | Tim Ledgerwood |
Post date | 2003-12-08T12:26:51Z |
At 12:07 PM 08/12/2003 +0000, you wrote:
Regards
Tim
[Non-text portions of this message have been removed]
>Tim,Shouldn't I rather just delete the indexes?
>since some of your indexes contain quite a few duplicates, it may be
>wise to add the PK to the end of these indexes. E.g. rather than
>having
>
>CREATE INDEX IDX_LOGSTOCK ON LOG(STOCK)
>
>do
>
>CREATE INDEX IDX_LOGSTOCK ON LOG(STOCK, ID)
Regards
Tim
[Non-text portions of this message have been removed]