On 29 Mar 2005 at 9:24, Christian Kaufmann wrote:

>> 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 don't think so. It looks like almost perfect selectivity.

>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?

Backup and restore.
--
SY, Dimitry Sibiryakov.