Re: [firebird-support] Installing Firebird 2.5 on Debian 9 Stretch

2019-01-22 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
On 21/1/19 7:37 pm, Ertan K���ko�lu ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > Hello, > > There was an old server running Debian 7. That server crashed and had to be > installed. Service provide did not have Debian 7 in install OS list and now > it runs Debian 9. Seemingly, De

[firebird-support] How to "shape" indexes to avoid index depth > 3

2019-01-22 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Hey all, In my database I have some indexes with depth = 4 (db page size is already 16KB). The indexes are multi-segment, with the fields sequenced from least to most selective, and gstat reports a very low selectivity for the index (less than 0.0001). The indexed tables have between 100