| Subject | Re: [firebird-support] Re: How to "shape" indexes to avoid index depth > 3 |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2019-01-29T22:30:09Z |
29.01.2019 21:13, 'Leyne, Sean' Sean@... [firebird-support] wrote:
much selectivity it lose and how much performance would be affected.
--
WBR, SD.
> the multi-segment indexes are to optimize commonly used queries.In this case you can consider removing one or two fields from the index and see how
much selectivity it lose and how much performance would be affected.
--
WBR, SD.