|Subject||Re: [firebird-support] index vs page size|
On Jun 20, 2019, at 11:10 AM, Nick Upson nu@... [firebird-support] <firstname.lastname@example.org> wrote:
I have a large 100Gb+ firebird 2.5 database and I'm trying to deal with some performance issues.
One indicator I have found is that several large tables have indexes with a depth of 3 (and one of 4). The guidance I have seen says to increase the page size until the depth is below 3 but the pagesize is already maxed out at 16k. Can anyone suggest other actions I could take.
The guidance should have been three or less, not less than three. One index with four levels should not be a crisis if you have adequate page cache.