| Subject | Re: [firebird-support] Index Selectivity |
|---|---|
| Author | Aage Johansen |
| Post date | 2003-12-08T20:28:59Z |
On Mon, 8 Dec 2003 12:26:03 +0000 (UTC), Tim Ledgerwood wrote:
performance on deletes (and updates?). Consider Svein Erling's advice of
changing index definitions to something like
CREATE INDEX IDX_LOGSTOCK ON LOG(STOCK, The PrimaryKey)
It won't help SELECTs, but can do wonders for DELETEs.
--
Aage J.
> ...These max dups of 32000 and more will probably come back and kill
> Index IDX_LOGSTOCK (3)
> Depth: 3, leaf buckets: 1120, nodes: 179393
> Average data length: 0.00, total dup: 178416, max dup: 32723
> ...
performance on deletes (and updates?). Consider Svein Erling's advice of
changing index definitions to something like
CREATE INDEX IDX_LOGSTOCK ON LOG(STOCK, The PrimaryKey)
It won't help SELECTs, but can do wonders for DELETEs.
--
Aage J.