Subject Re: Performance when deleting a lot of records
Author Christian Kaufmann
> Make your indices as unique as possible. You may add a PK field to
> of index fields.

I have duplicates in some indexes. Mostly there are 2-10 records with
the same key. Should I add a field to make the key unique in that
case?

I noticed in the statistics, that I have 3'000'000 nodes in the index,
but the table has only 2'100'000 records. To the nodes represent the
number of possible records in all allocated pages for that index?

Index depth is 3, my page size is 4096. I read somewhere, that
increasing the page size helps with performance. How can I change the
page size of my database?

cu Christian